SUMIF non adjacent cells

[edminty84]

Hi,
I am having trouble using the SUMIF function as my range of cells are not adjacent, but separate and using commas between the cell range is throwing off the calculation.

I am trying to add up scores above 10 as only these count towards a total score.
Cells to be totaled are E6, I6 & M6.

Is there anyway around this please?

Thanks

 

[Fluff]

Hi & welcome to MrExcel.
A couple of options

=SUM((E6>10)*E6,(I6>10)*I6,(M6>10)*M6)

=SUMPRODUCT((E6:M6>10)*(MOD(COLUMN(E6:M6),4)=1)*(E6:M6))

 

[edminty84]

Hi & welcome to MrExcel.
A couple of options

=SUM((E6>10)*E6,(I6>10)*I6,(M6>10)*M6)

=SUMPRODUCT((E6:M6>10)*(MOD(COLUMN(E6:M6),4)=1)*(E6:M6))

Hi,
Thanks for that. The first one worked great thanks.

 

[Fluff]

You're welcome & thanks for the feedback.