SUMIFS only for certain criteria...

I have a spreadsheet with approx. 500 rows and about 25 columns of data - I've added several summary rows at the top of the sheet to sum 2 of the columns according to 6 criteria which appear in other columns.
This is easily done using a SUMIF formula - and I've put one SUMIFS statement in to sum the 2 columns I need if ALL of the 6 criteria are selected - again not too difficult.
What I can't think of an easy way to do is to summarise data if I only want to pick 3 or 4, say, of the criteria - obviously without having to write SUMIFS for all of the possible different combinations.
There are no blanks or zeros in any of the cells in the sheet - each item(row) has something assigned for each of the criteria I'm looking at.
Any ideas appreciated.

I have some ideas, but it would help if you attached a sample Excel workbook so we can see what type of data we are dealing with, and how it is laid out.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Please note that the Paperclip icon does not work.

Pete

Pete,
Thanks - I will do, just need to anonomousalyzemate the data and upload......

Some time later...
Had to do this from scratch so hopefully this will give an idea of what I'm trying to achieve.

Try

=SUMIFS(E:E,I:I,$O$3,D:D,$O$4,C:C,$O$5,H:H,$O$6,K:K,$O$7,J:J,$O$8)

Make your selections DV lists and include "*" (without quotes) as a criteria in the lists (meaning ALL).

Thanks John - I'd tried adding a blank to the DV lists but hadn't thought of that...
Fantastic!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.