| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF Formula Problem
Hi to all,
Wonder if you can help me. I have the following formula which works ok, is it possible to have a similar formula but with extended choice of cells: SUMIF('1'!A:A,A5,'1'!J:J) Example: The present formula will compare 1!A:A with A5, I would like a formula to compare 1!A:A,A5 and 1!B:B giving the same result from 1J:J 1!A:A being a category like Travel Expenses, 1!B:B being a department like Sales Department 1!J:J being the Cost Thank You Albert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with SUMPRODUCT(SUMIF(INDEX formula linking to external fi | Excel Worksheet Functions | |||
| SUMIF and SUMPRODUCT with INDIRECT formula problem | Excel Discussion (Misc queries) | |||
| Help me on SUMIF Problem!!! | Excel Discussion (Misc queries) | |||
| Problem with Sumif formula | Excel Worksheet Functions | |||
| sumif problem | Excel Discussion (Misc queries) | |||
Threaded Mode
