Counting based on values in two columns?

B

Brother of Andrew

I have a table like this (more or less)

A yes
B no
A no
C yes
A no
c yes

I want to know how many A's are there and how many are yes and how many are
no? same for B, C...Thank you!
 
J

John Michl

I agree with the pivot table, especially if there is alot of data.
However, to do this with a formula you could use the following:
=SUMPRODUCT(--(A1:A20="A"),--(B1:B20="Yes"))
Assuming, of coursem that the data ranges are equal in length and from
rows 1 through 20. Change the "Yes" to "No" to get the other value.

- John
www.JohnMichl.com
 
B

Brother of Andrew

Thanks all! I taught myself how to do a pivot table and I'm good to go!

God's peace.
 
Top