If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Please Help with Formula
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Converting a SUMPRODUCT formula to COUNTA active... | BeSmart | Worksheet Functions | 8 | March 27th, 2004 03:36 PM |
Alternative formula to HLookup | Bernie Deitrick | Worksheet Functions | 0 | March 26th, 2004 12:53 PM |
Offset formula | Frank Kabel | Worksheet Functions | 5 | March 15th, 2004 09:50 PM |
Dynamic formula to sum across rows | turtleman2 | Worksheet Functions | 5 | March 8th, 2004 08:11 PM |
Sheet Names | Joseph M. Yonek | Worksheet Functions | 6 | January 3rd, 2004 02:15 AM |