Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi
I am having trouble summing a range of cells that meet multiple criteria. I have 3 resources clin040, clin060 and clinmix. These resource codes appear in column K. Column K also contains many other resource codes. I need to sum all the cells in column AL that have either clin040, clin60 or clinmix in column K. I also need to do this over a number of sheets - clin1, clin2 clin3 etc to clinEND, and have a total of all cells with those resources across all the sheets. Please help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
SUMIF across a range of worksheets | Excel Worksheet Functions | |||
Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
SUMIF multiple criteria | Excel Worksheet Functions | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |