Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |