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...