SUMIF with SUMPRODUCT
 

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!

SUMIF with SUMPRODUCT
 

Hi,

Try this

=SUMPRODUCT((YEAR(A1:A200)=2008)*(D1:D20020.05)*( D1:D200<40.199)*(H1:H200))

Mike

"WildWill" wrote:

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!

SUMIF with SUMPRODUCT
 

THanks Mike! Sorted

"Mike H" wrote:

Hi,

Try this

=SUMPRODUCT((YEAR(A1:A200)=2008)*(D1:D20020.05)*( D1:D200<40.199)*(H1:H200))

Mike

"WildWill" wrote:

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!