Sum if or Count if with dates or any other formula that would work

[Jeremy]

I am wanting to use that data below to give me the totals in B that are 0 to
10 days based off of A and the date on the computer. I want to put this in
C1. Also I am wanting to use a formula to give totals in B that are 11 to 20
days based off of a and from the date on the computer. I want to put this in
C2.


A B C
1 3/23/08 26.48
2 4/20/08 0.00
3 4/16/08 2.48
4 3/18/08 46.81
5 3/10/08 0.00
6 4/12/08 42.00

 

[Bob Phillips]

=SUMPRODUCT(--($A$1:$A$6>TODAY()-10),$B$1:$B$6)

and

=SUMPRODUCT(--($A$1:$A$6>TODAY()-20),$B$1:$B$6)-C1

--
---
HTH

Bob


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