SUMIFS and a column range Table_References

[smitht3]

Hi folks,

I'm sure i must be missing something obvious here. I must be Googling using the wrong terms.

Is it possible to use SUMIFS on a range of columns?
=SUMIFS(Table[[Column3]:[Column10]],Table[Column1],01/01/2000,Table[Column2],Name)

There are quite a few columns to include in the SUM so i would prefer not to have a SUMIF + SUMIF + SUMIF.

Is there a SUMPRODUCT option? i'm not too clever with using it.

Thanks

[mazamizo567]

Could you sent a file to clarify

[Aladin Akyurek]

@smitht3

Control+shift+enter, not just enter:

=SUM(IF(Table1[Column1]="01/01/2000"+0,IF(Table1[Column2]="Joe",Table1[[Column3]:[Column10]])))

[smitht3]

@smitht3

Control+shift+enter, not just enter:

=SUM(IF(Table1[Column1]="01/01/2000"+0,IF(Table1[Column2]="Joe",Table1[[Column3]:[Column10]])))

That worked perfectly.

Thank you