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