Hi
use SUMIF for this

--
Regards
Frank Kabel
Frankfurt, Germany


William Tyler wrote:
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