Counting between dates

O

okanem

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$50000)

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
 
B

Bob Phillips

=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)
 
Top