Using SUMIF to add data between a range of dates
Hi
With start date in B20 and end date in B21 try this:
=SUMIF(C2:C5,"=" &B20,B2:B5)-SUMIF(C2:C5,"<="&B21,B2:B5)
Regards,
Per
"Jaspa" skrev i meddelelsen
...
Hi, I am developing a cashflow spreadsheet, and need to add a range of
values
(in column B) based on the criteria that they are relating to a set week,
ie
in column B has the amount to be paid, and column C has the date the
amount
is due. I need to find out the total amount due between 2 dates. Does
anyone
know how I can do this?
|