Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF using criteria from a list
This one seems easy but I can't figure it out.
A B 1 Acct Amt 2 100 54 3 101 76 4 102 84 5 103 67 6 104 99 7 105 42 8 106 0 9 107 81 How can I take the total sum of accounts (for example) 102,104 & 107. So I am looking for an answer of 84 + 99 + 81 = 264. I will normally use around 15 - 20 accounts. Do I need a separate SUMIF formula for each account, or can I set up one and input a list of accounts for the criteria?? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif with four criteria??? | Excel Discussion (Misc queries) | |||
SumIf with OR criteria | Excel Worksheet Functions | |||
Sumif with criteria list | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF Criteria | Excel Discussion (Misc queries) |