Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF / SUMPRODUCT | Excel Worksheet Functions | |||
HELP !!! SUMIF or SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumif or Sumproduct? Maybe neither? | Excel Worksheet Functions | |||
sumif vs sumproduct | Excel Worksheet Functions | |||
Sumif not Sumproduct | Excel Worksheet Functions |