Forum Discussion
Solved
Combine SUMIFS function with OR function
Hello to everyone. I need to create a formula that returns a SUM with different criterias, but I'm not getting it. I have a table Colum 1 | Column 2 | Column 3 Date | Price | Typ...
How about
=SUM(SUMIFS(C26:C35; D26:D35; AM3; K26:K35; {1;2;3}))
or
=SUMPRODUCT(C26:C35; (D26:D35=AM3)*((K26:K35=1)+(K26:K35=2)+(K26:K35=3)))
- Thank you for your reply!.
The thing is that the field "Type" will grow exponentially, so I will need to specify and create SUMS over more than 50 different types, so that's why I need to find the way to mark wich ones need to be considered for the SUMHow about
=SUM(SUMIFS(C26:C35; D26:D35; AM3; K26:K35; {1;2;3}))
or
=SUMPRODUCT(C26:C35; (D26:D35=AM3)*((K26:K35=1)+(K26:K35=2)+(K26:K35=3)))
- Didn't know you could filter like your first example "{}".
Many thanks for taking the time, this is solivng my issue!
