formula for excel spreadsheet

[Pam]

I am trying to creat a formula in my accounting spreadsheet that will put the
total in the appropriate column by the date column plus 0-30 days or next
column plus 31-60 days. I tried the sumif and kept getting errors. Help.

 

[Eduardo]

Hi,
could you provide an example thanks

 

[Pam]

column c is a date format, column d is the total column, each column after
that is 0-30, 31-60, 61-90, 91-119,120-150,150+ respectively. I would like
the total in d to automatically transfer to each of these columns as the
number of days increase from the original date. Is that possible?

 

[Pam]

I tried this formula and got the result for one column, however when I
changed the date past 30 days it did not change the results.
=IF(C6+(0-30),D6,0)

 

[Eduardo]

Hi,
in the column of 0-30 enter

=IF((TODAY()-$C$3)<=30,$D3,"")

31-60

=IF(AND((TODAY()-$C$3)>30,(TODAY()-$C$3)<=60),$D3,"")

61-90

=IF(AND((TODAY()-$C$3)>60,(TODAY()-$C$3)<=90),$D3,"")

91-119

=IF(AND((TODAY()-$C$3)>90,(TODAY()-$C$3)<=119),$D3,"")

120-150

=IF(AND((TODAY()-$C$3)>119,(TODAY()-$C$3)<=150),$D3,"")

+150

=IF(AND((TODAY()-$C$3)>119,(TODAY()-$C$3)<=150),$D3,"")

then copy formulas down

 

[Eduardo]

opps I found a mistake use this ones in each column and then copy
=IF((TODAY()-$C3)<=30,$D3,"")
=IF(AND((TODAY()-$C3)>30,(TODAY()-$C3)<=60),$D3,"")
=IF(AND((TODAY()-$C3)>60,(TODAY()-$C3)<=90),$D3,"")
=IF(AND((TODAY()-$C3)>90,(TODAY()-$C3)<=119),$D3,"")
=IF(AND((TODAY()-$C3)>119,(TODAY()-$C3)<=150),$D3,"")
=IF((TODAY()-$C$3)>150,$D3,"")

 

[Eduardo]

in last formula use
=IF((TODAY()-$C3)>150,$D3,"")

the problem was that I enter C between $ so the calculation will always look
to that cell

 

[Eduardo]

hi,
see the formulas given before my two last post

 

[Pam]

Thank you Eduardo, I was out of the office for a couple of days. I will try
the formulas and let you know.

 

[Pam]

without being too much of a pain, can you explain the formula. It worked
great!!!