S
S
spacekonducta2021-08-05 15:48:02
Google Sheets
spacekonducta, 2021-08-05 15:48:02

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)

And the task is, for example: There are three managers, the total number of "Anonymous" is derived by the formula and is known. You need to adapt the formula (or use another one) to display the number of Anonymous for each manager (use an additional parameter). Screenshot example:610bdf5a5d46b439485527.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
BasiC2k, 2021-08-05
@spacekonducta

SUMIFS ?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question