SUMIF with SUMPRODUCT

[WildWill]

Hi

I have a data set (A1:X200), which contains (amongst others) the following
columns:

Column A = Date in format "03-Feb-2009"
Column D = Potato sizes in the format "X.XX", e.g. 34.29
Column H = Cost of Potato in "$"

I want to use a SUMPRODUCT to calculate the total cost of potatoes (across
the entire span of entries) where the date value ="2008", and where the
potatoes are bigger than "20.050" and smaller than "40.199".

Please help!

 

[Mike H]

Hi,

Try this

=SUMPRODUCT((YEAR(A1:A200)=2008)*(D1200>20.05)*(D1200<40.199)*(H1:H200))

Mike

 

[WildWill]

THanks Mike! Sorted

Hi,

Try this

=SUMPRODUCT((YEAR(A1:A200)=2008)*(D1200>20.05)*(D1200<40.199)*(H1:H200))

Mike