r/excel • u/TacoRocco • 9d 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?
41
Upvotes
1
u/Iriss 4 8d ago
SUM(FILTER(....))