Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I can't think of a short title for this
Ok this is what I have. I have a list of accounts: 100-2, 100-3, 200-2,
200-4, 400-2, 400-3, 400-4, etc. all in one column. Then I have the balances for each of these accounts in another column. What I am trying to do (with no success thus far) is create a formula that takes all the accounts that end in "2" and add them together, all the accounts that end in "3" and add them together etc. I figured that I would need a formula for each check digit but I cannot figure out how to get it to work. I have used SUM, IF, CHOOSE, in all kinds of variations. I am stuck. Is this something I can actually do? If it is, who wants to be my saviour today? :-) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
short key | Excel Discussion (Misc queries) | |||
Named range=Column title,comumn title in cellB6 use B6in equation | Excel Discussion (Misc queries) | |||
Show full path title in title bar? | New Users to Excel | |||
Pasting Objects into Chart title and Axis title | Charts and Charting in Excel | |||
short cut key | Excel Discussion (Misc queries) |