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!
You didn't show your formulas, so I can't tell you what you've possibly have been doing wrong.
It's straight forward SUMIFS() and COUNTIFS().
I suppose every row is equal to 1 item since there is no distinct field "Item".