Hi, Here I am again still trying to learn and somehow lost once more. So i turn to this site which has bailed me out multiple times in hopes that i haven't gone to the well to often.

Here's my problem right now. Under column B, I have numbers (1,2,3) and in column C I have letters (a,b,c). I know that by sing the =COUNT formula I can count the number of 1s, 2s, and 3s under column b as well as the number of As, Bs, and C,s under column C. What I am trying to achieve though is to count how many cells that contain "A" are under column C where Column B shows the number 1.

I know this is just a formula which I can't seem to find. Hopefully someone can point me to the right direction.

Thanks!

To start with, you should be very careful when posting examples of your data. First you said

in column C I have letters (a,b,c)

Then you saidthe number of As, Bs, and C,s under column C.When you mix cases, you confuse the poor reader. Are you trying to count lower case letters or uppercase letters?

Assuming you meant lower case, a formula of this type should do it for you:

=SUMPRODUCT(($B$1:$B$12=1)*($C$1:$C$12="a"))

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History