CODEWITHSUNDEEP
excelexcel-formula
Mateusz Jablonski
Mateusz Jablonski

Reputation: 9

Counting cells when in another cell there is specific value

Hi i need to count column of cells where specific value is when in another cell has specific value. I am using countifs function but i get and error. The cell G6 is drop down list when i want to change the word between MULTI and SINGLE and count the cells in "Page1" from the column when there is "Multi" Or "Single"

My code:

COUNTIFS(G6;"MULTI";'Page1'!B:B;"Multi")

How can I do it? Can you help please?

Upvotes: 0

Views: 1464

Answers (1)

JvdV
JvdV

Reputation: 75960

Your error is because your ranges are not the same. That being said, it looks like you need something like:

=COUNTIF('Page1'!B:B;G6)

Otherwise maybe a nested IF() to check if G6 has "MULTI" or "SINGLE" or another value in it.

Upvotes: 1

Related Questions