Conditional Counting of Arrays

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")
 
F

Frank Kabel

Hi
try
=SUMPRODUCT((B3:B32<>"")*(C3:C32="X"))

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to count based on multiple criteria & cell comparisons 4
Counting unique instances of a text string 2
Count Blank Cells with Conditions 3
How to count a coloum if two conditions are met 5
need help on either doing a loop and counting specific values orusing subtotal function 2
Needs help combining functions. 3
Count Number of Unique Cells That Don't Have Certain Characters 0
Finding the weighted average of text that have been given values 1

Top