0

I have a table where I need to count cells with the value "B" in C2:C9 but only if the corresponding row in E2:E9 isn't blank: ![table

I got this formula from this similar question: COUNTIF inside COUNTIFS:

=SUM(COUNTIFS(C:C, "B"),E:E,"<>"&"")

but am receiving the #VALUE! error. I'm assuming I need to add something that will match up the C and E columns with the appropriate row

Thanks

Zacchini
  • 143
  • 13

1 Answers1

1

I'm not sure why you are using SUM and COUNTIFS, you can get the result with COUNTIFS.

=COUNTIFS(C2:C9, "B", E2:E9, "<>")
norie
  • 9,609
  • 2
  • 11
  • 18