Sumifs multiple but same criteria, better solution?

[gobblechops]

Hi all,

Below is an example of a simple sumifs formula.

=SUMIFS(A3:A15,C3:C15,0,D3:D15,0,E3:E15,0,F3:F15,0)

Is there an alternative to this, bearing in mind more columns could be added but will the same criteria i.e (0)?

I am sure the must be an alternative, maybe sumproduct and using a one range in the formula that could be altered when more columns are added but I am not sure?

Any help appreciated!

Thanks.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1110294-sum-sum-criteria-post5344587.html#post5344587

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).