Forum Discussion
Solved
Need formula help for countifs and sumifs
Hi - trying to create some formulas for countifs and sumifs. I need to count and sum if the data meet specific criteria in a few different columns. Specifically, I'd like to exclude certain things ...
- That is a great solution, OliverScheurich - I very much appreciate the alternative option!
An alternative could be SUMPRODUCT.
=SUMPRODUCT(($C$2:$C$19=H3)*($F$2:$F$19=$J$2)*($E$2:$E$19<>$I$2))
- That is a great solution, OliverScheurich - I very much appreciate the alternative option!