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?
|