Conditional Counting of Arrays

  • Thread starter Thread starter rbrychckn
  • Start date Start date
R

rbrychckn

I have a worksheet that has the following structure:

A B C


In Column B is a unique ID for the row (4-digit number). In C i
either an "X" or a blank as a yes/no column.

I want to count the number of X's in Column C only if they have an I
in Column B. I've used the COUNTIF function with an IF statement bu
it's giving me #NUM/#VALUE errors. Any help would be great.

{=COUNTIF((IF((B3:B32<>0),(C3:C32))),"X")
 
Hi
try
=SUMPRODUCT((B3:B32<>"")*(C3:C32="X"))

or
=SUMPRODUCT(--(B3:B32<>""),--(C3:C32="X"))
 
Back
Top