Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum if or Count if with dates or any other formula that would work
=SUMPRODUCT(--($A$1:$A$6TODAY()-10),$B$1:$B$6)
and =SUMPRODUCT(--($A$1:$A$6TODAY()-20),$B$1:$B$6)-C1 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jeremy" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to count cells between dates. | Excel Worksheet Functions | |||
Formula to count number of dates in an array | Excel Worksheet Functions | |||
Formula that will count between dates ranges | Excel Worksheet Functions | |||
Formula that will count between dates ranges | Excel Worksheet Functions |