SUMIF/PRODUCT & DATES

S

Sarini

Basically I have a column with various dates in, and a column next to it with
amounts in. I want make 5 formulas to calculate the sum of the amounts but
only between certain dates. So for instance the first calculation would be
the sum of the amounts in column B but only amounts next to dates which fall
between 30/03/07 and 30/03/08 in Column A
 
D

driller

u have 2 columns A n B, Date and amounts, respectively
on c1 = your start date source
on c2 = your end date source
on c3 = sumproduct(($A$1:$A$10>=C1)*($A$1:$A$10<=C2),($B$1:$B$10))

for the other four formula
select c1:c3 >copy >paste to d1:g3

regards
 
B

Bob Phillips

=SUMIF(A:A,">="&date1,B:B)-SUMIF(A:A,">"&date2,B:B)



--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top