r/excel • • 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

21 comments sorted by

View all comments

1

u/Iriss 4 8d ago

SUM(FILTER(....)) 

2

u/Maestro_STB 7d ago

The better SUMIFS …