View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Space Elf
 
Posts: n/a
Default Criteria in SUMIF

I'm trying to use SUMIF to total a range of numbers. I'd like to get the
results for a particular month but I can't figure out how to use a date range
under criteria. It only seems to let me choose greater than or less than one
date.

Is there a way to use an equivalent criterea argument like 4/30/2005 &
<6/1/2005
in order to add all values in a column when the corresponding date column is
in the month of May 2005?