Answer the question
In order to leave comments, you need to log in
How to use SUMIF with multiple columns?
This is how I use this formula to count the number of rows with the value "Anonymous" in a column. This is how I calculate the total.
=SUMIF('Data'!B:B, "Anonymous", 'Data'!P:P)
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question