formula for excel spreadsheet
 

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.

formula for excel spreadsheet
 

Hi,
could you provide an example thanks
"Pam" wrote:

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.

formula for excel spreadsheet
 

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?

"Eduardo" wrote:

Hi,
could you provide an example thanks
"Pam" wrote:

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.

formula for excel spreadsheet
 

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" wrote:

Hi,
could you provide an example thanks
"Pam" wrote:

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.

formula for excel spreadsheet
 

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



"Pam" wrote:

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?

"Eduardo" wrote:

Hi,
could you provide an example thanks
"Pam" wrote:

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.

formula for excel spreadsheet
 

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" wrote:

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



"Pam" wrote:

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?

"Eduardo" wrote:

Hi,
could you provide an example thanks
"Pam" wrote:

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.

formula for excel spreadsheet
 

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" wrote:

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" wrote:

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



"Pam" wrote:

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?

"Eduardo" wrote:

Hi,
could you provide an example thanks
"Pam" wrote:

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.

formula for excel spreadsheet
 

hi,
see the formulas given before my two last post

"Pam" wrote:

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" wrote:

Hi,
could you provide an example thanks
"Pam" wrote:

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.

formula for excel spreadsheet
 

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

"Eduardo" wrote:

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" wrote:

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" wrote:

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



"Pam" wrote:

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?

"Eduardo" wrote:

Hi,
could you provide an example thanks
"Pam" wrote:

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.

formula for excel spreadsheet
 

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

"Eduardo" wrote:

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" wrote:

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" wrote:

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



"Pam" wrote:

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?

"Eduardo" wrote:

Hi,
could you provide an example thanks
"Pam" wrote:

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.