View Single Post
  #1  
Old April 27th, 2010, 10:40 PM posted to microsoft.public.excel.worksheet.functions
Kathy
external usenet poster
 
Posts: 641
Default if function help

i am trying to create an if function that will sum data in a column if the
cell value is between certain values.
This works for sum if greater than, =ifsum(b:4:b14,"366",e4:E14)
When I try to have the sum of E4:e14 if b4:b14 is between 151 and 366 I am
unable to get the criteria written correctly. HELP!
--
Thank you, Kathy