|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 25th, 2009, 11:41 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT
I need to calculate the total ($) collected between 8/17 & 8/24 if the value
of the cooresponding data in column N is "1". Here is the formual so far (for the data collection between the specific dates): =SUMPRODUCT(--([Book1]Sheet1!A5:A1000=DATEVALUE("8/17/2009")),--([Book1]Sheet1!A5:A1000=DATEVALUE("8/24/2009")). How do I modify the formula to only total the collections if N is "1"? 
|
|
#2
August 26th, 2009, 01:27 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMPRODUCT
Besides the criteria for column N, you also don't have the $ range you want
to total. In the formula below, I've assumed it's in column B, but you can adjust as needed: =SUMPRODUCT(--([Book1]Sheet1!A5:A1000=DATEVALUE("8/17/2009")),--([Book1]Sheet1!A5:A1000=DATEVALUE("8/24/2009")),--([Book1]Sheet1!N5:N1000=1),[Book1]Sheet1!B5:B1000) "Dhardy" wrote: I need to calculate the total ($) collected between 8/17 & 8/24 if the value of the cooresponding data in column N is "1". Here is the formual so far (for the data collection between the specific dates): =SUMPRODUCT(--([Book1]Sheet1!A5:A1000=DATEVALUE("8/17/2009")),--([Book1]Sheet1!A5:A1000=DATEVALUE("8/24/2009")). How do I modify the formula to only total the collections if N is "1"?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
