gobblechops
New Member
- Joined
- Apr 27, 2017
- Messages
- 40
- Office Version
- 365
- Platform
- Windows
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.
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.