View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeremy Jeremy is offline
external usenet poster
 
Posts: 184
Default Sum if or Count if with dates or any other formula that would work

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