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

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

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