Please help with Formula

  • Thread starter Thread starter wst - ExcelForums.com
  • Start date Start date
W

wst - ExcelForums.com

Hello,

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

For example

Column D = Account No
Column E = Amount (in Dollars
Column I = Total for the Mont

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

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

Thank
Willia
 
Since the actual question was for a *totaling* formula, one way would be to
use this, and copy down as far as needed.

This will give you a running total.

The specific account number to total should be entered in G1.
This allows you to check different accounts without changing the formula
itself.

=SUMIF($D$1:D1,$G$1,$E$1:E1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


One way:

I1: =IF(D1=4,E1,"")

copy down as far as required.
 
You could use =SUM(IF(D1:D16=4,IF(E1:E16>0,E1:E16,0)))
When entering this use CTRL+SHIFT+ENTER to set as an array.
The ranges would be set to cover all of the accounts you have for tha
month.
If you need another cell giving the total for account number 5, the
change =4 to =5
 
Back
Top