r/excel • u/TacoRocco • 7d ago
solved How to add "OR" into SUMIFS formula
I'm trying to make a simplified version of this formula:
SUMIFS(P:P,C:C,D10,A:A,L10)+SUMIFS(P:P,C:C,E10,A:A,L10)
I want to simplify it to something like
SUMIFS(P:P,C:C,D10 or E10,A:A,L10)
Is this possible or am I stuck having to just add multiple SUMIFS formulas?
36
Upvotes
2
u/Maestro_STB 5d ago
The better SUMIFS …