Sumif formula
One way...
B13 = lower date boundary
B14 = upper date boundary
=SUMPRODUCT(--(A20:A1000=B13),--(A20:A1000<=B14),C20:C1000)
--
Biff
Microsoft Excel MVP
"Ron0210" wrote in message
...
How do you write a sumif formula using a range for the criteria. For
example:
=sumif(a20:a1000,b13:b14,c20:c1000) which does not seem to work. My
spreadsheet has a series of dates in column a with corresponding values
column c and I want to sum column c for a particular range of dates
defined
by b13 and b14. A typical range would be a month. My spreadsheet will
have
dates and values and I want to determine sums for certain months.
|