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.