LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Mike@Q
 
Posts: n/a
Default SUMIF multiple criteria in 1 range

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMIF with only one criteria cell within range Stan Excel Discussion (Misc queries) 5 December 16th 04 10:12 PM
SUMIF across a range of worksheets Mike@Q Excel Worksheet Functions 3 November 24th 04 02:36 PM
Counting "rows", i.e. simultaneous criteria for multiple cells gkline Excel Worksheet Functions 2 November 19th 04 07:30 AM
SUMIF multiple criteria LOU Excel Worksheet Functions 1 November 10th 04 07:12 PM
Can I use a cell reference in the criteria for the sumif function. Number Cruncher Excel Worksheet Functions 2 November 4th 04 07:52 PM


All times are GMT +1. The time now is 09:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"