SUMIF with SUMPRODUCT

  • Thread starter Thread starter WildWill
  • Start date Start date
W

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!
 
Hi,

Try this

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

Mike
 
Back
Top