# of days - if & count statements
One way would be =COUNTIF(A1:A10,"<60")-COUNTIF(A1:A10,"30") where you're
just subtracting the count of days greater than 30 from the count of days
less than 60.
Dave
--
Brevity is the soul of wit.
"Karen Smith" wrote:
How would i say greater than 31 days less than 60 days?
"stevebriz" wrote:
for the count of days <31
If the Range of days is A1 : A10
=COUNTIF(A1:A10,"<31")
For the sum of money <31 days amounts in col B1:B10
= SUMIF(A1:A10,"<31",B1:b10)
Karen Smith wrote:
I need to create 2 formulas on the following table ....1 how many records are
0-30 days (answer 4) and 2ndly how much money are in 0-30 days (answer $750)
For example
# of Days $
28 150
34 100
22 100
44 100
1 200
32 50
5 300
|