Sumif with staggered columns

1057 views excel

I would like to add the rows if the value in each cell is less than 100 and if the columns headings were "Tom", "Dick" and "Harry"

So in Row 1, only Dick is less than 100 so the sum is 7.

In Row 2, Tom and Harry are less than 100 individually so the sum is 79.

I have over 30, 250x250 matrices where I would like to get conditional sums of a seven staggered columns. All the combinations of SUMIFs I have tried seem to be giving errors.

I don't just want to add, I would like to be able to do other things, like just count how many times Tom, Dick, and Harry have individually less than 100 or calculate other statistics like mean, median etc.

enter image description here

answered question

1 Answer


You could use IF(AND your formula conditions here). That way you can specify as many conditions on each column as you like.

I can help with syntax if you get stuck.

Best wishes

posted this

Have an answer?


Please login first before posting an answer.