View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WildWill WildWill is offline
external usenet poster
 
Posts: 64
Default 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!