Please Help with Formula

[William Tyler]

Hello,



Could someone please help me with the following? I'm trying to come up with
a formula that will total specific cells if certain conditions exist.



For example:



Column D = Account No.

Column E = Amount (in Dollars)

Column I = Total for the Month



Every time Column D has the Account Number 4 placed in it with the dollar
amount in Column E, I need a formula in Column I that will total the dollar
amounts (of Column E) each time the Account Number is 4 (in Column D).
Keeping in mind that Column D will have other Account Numbers other then the
number 4 throughout the month. That why I'm thinking it should be an "IF
Then" condition in the formula (although I could be wrong, there could be
another statement that could be used that I'm not a where of).



Any help you could give me on this would be greatly appreciated.



Thanks

William

 

[Ron Rosenfeld]

Hello,



Could someone please help me with the following? I'm trying to come up with
a formula that will total specific cells if certain conditions exist.



For example:



Column D = Account No.

Column E = Amount (in Dollars)

Column I = Total for the Month



Every time Column D has the Account Number 4 placed in it with the dollar
amount in Column E, I need a formula in Column I that will total the dollar
amounts (of Column E) each time the Account Number is 4 (in Column D).
Keeping in mind that Column D will have other Account Numbers other then the
number 4 throughout the month. That why I'm thinking it should be an "IF
Then" condition in the formula (although I could be wrong, there could be
another statement that could be used that I'm not a where of).

From your description, it seems as if each table represents one month.

To sum account #4:

=SUMIF(D,4,E:E)


--ron

 

[William Tyler]

Thanks Ron for your reply!

I'll give this a try.

Thank you
William

 

[William Tyler]

Hello Ron,

I tried that formula and it's exactly what I needed. Thanks again.

I have one more question;

Could you help me with a formula that will allow me to carry over the totals
from one worksheet to another (i.e carry totals in cell K2 of sheet1 to cell
J2 of sheet2).

Thanks
William

Thanks Ron for your reply!

I'll give this a try.

Thank you
William

 

[Frank Kabel]

Hi
in J2 enter
='sheet1'!K2

 

[Ron Rosenfeld]

Hello Ron,

I tried that formula and it's exactly what I needed. Thanks again.

I have one more question;

Could you help me with a formula that will allow me to carry over the totals
from one worksheet to another (i.e carry totals in cell K2 of sheet1 to cell
J2 of sheet2).

Select the cell on Sheet2 where you want the total.
Type the equal sign: =
Select the cell on Sheet1 that you wish to carry from.
<enter>

In Sheet2 J2 should be the formula =Sheet1!K2


--ron