Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting between dates
I need to count the quantities relating to the code AA between two dates. I use =SUMIF(Data!$E$4:$E$50000,"AA",Data!$BB$4:$BB$5000 0) to count the quantities relating of AA where dates are not needed. Also I have in the past used the =SUMPRODUCT(('Rec Data'!$A$5:$A$209=Overall!$C$2)*('Rec Data'!$A$5:$A$209<=Overall!$C$3)*('Rec Data'!$B$5:$B$209)) in another spreadsheet to total values between two dates. I need to somehow incorporate the SUMIF into the end of the SUMPRODUCT formula to only count quantities relating to AA between two dates entered. Anyone any ideas! Rgds Okanem -- okanem ------------------------------------------------------------------------ okanem's Profile: http://www.excelforum.com/member.php...fo&userid=9301 View this thread: http://www.excelforum.com/showthread...hreadid=558123 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting between dates
=SUMPRODUCT(--('Rec Data'!$A$5:$A$209=Overall!$C$2), --('Rec Data'!$A$5:$A$209<=Overall!$C$3), --(Data!$E$4:$E$50000="AA"),'Rec Data'!$B$5:$B$209) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "okanem" wrote in message ... I need to count the quantities relating to the code AA between two dates. I use =SUMIF(Data!$E$4:$E$50000,"AA",Data!$BB$4:$BB$5000 0) to count the quantities relating of AA where dates are not needed. Also I have in the past used the =SUMPRODUCT(('Rec Data'!$A$5:$A$209=Overall!$C$2)*('Rec Data'!$A$5:$A$209<=Overall!$C$3)*('Rec Data'!$B$5:$B$209)) in another spreadsheet to total values between two dates. I need to somehow incorporate the SUMIF into the end of the SUMPRODUCT formula to only count quantities relating to AA between two dates entered. Anyone any ideas! Rgds Okanem -- okanem ------------------------------------------------------------------------ okanem's Profile: http://www.excelforum.com/member.php...fo&userid=9301 View this thread: http://www.excelforum.com/showthread...hreadid=558123 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting between dates
Bob, that worked perfectly Thanks a million Rgds Okanem -- okanem ------------------------------------------------------------------------ okanem's Profile: http://www.excelforum.com/member.php...fo&userid=9301 View this thread: http://www.excelforum.com/showthread...hreadid=558123 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting occasions dates occur between 2 dates | New Users to Excel | |||
Counting Dates | Excel Worksheet Functions | |||
Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
Counting occurences of a specific day between two dates | Excel Worksheet Functions | |||
counting entries between two dates? | Excel Worksheet Functions |