Sumifs multiple but same criteria, better solution?

Status
Not open for further replies.

gobblechops

New Member
Joined
Apr 27, 2017
Messages
24
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.
 
Status
Not open for further replies.

Forum statistics

Threads
1,082,500
Messages
5,365,935
Members
400,863
Latest member
kimtid

Some videos you may like

This Week's Hot Topics

Top