what is the formula for the sum of numbers from one date to anoth.

C

Coddie

In other words, I have a list of dates with hours and costs from January thru
December on one worksheet. I want to have another worksheet calculate the
quarterly numbers including hours, costs, etc. between January 1st and March
31st and then between April 1st and June 30th and so on. What is the formula
for the sum of numbers from one date thru another. I need to divide this one
worksheet into quarters. Thank you!
 
B

Bernard Liengme

Suppose the dates are in column E, the numbers to sum in column F
For the first quarter use =SUMIF(E1:E40,"<01-04-2005",F1:F40)
Note I'm Canadian so I use the dd/mm/yyyy format for dates - adjust as
needed.
For Q2 you could use
=SUMIF(E1:E40,"<01-07-2005",F1:F40)-SUMIF(E1:E4,"<01-04-2005",F1:F40) or
=SUMPRODUCT(--(E1:E40>31-03-2005),--(E1:E40<1-07-2005),F1:F40)

best wishes
 
Top