| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Sumif" on multiple values
Hi all, I feel a little sheepish posting this question, but I really can't
get this to work: I have a list of customer accounts in Sheet 1 column A, with sales turnover in column C. Some of those accounts belong to the same group of companies. I have the list of account numbers in, say Sheet 2 A1:A10. How do I sum the sales turnover of the accounts in Sheet 1 that appear on the list of account numbers in sheet 2? I've tried sumif and sum if as array functions, but I can't quite find the right formula to use. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I test values in 2 different columns in a "sumif" formula? | Excel Discussion (Misc queries) | |||
| "sumif" With Multiple Criteria! | Excel Worksheet Functions | |||
| help needed on "sumif function with multiple ifs" | Excel Discussion (Misc queries) | |||
| Can I apply a "score" based on multiple cell values? | Excel Worksheet Functions | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Threaded Mode
