SUM COUNTIF problem

  • Thread starter Thread starter AD Carvajal
  • Start date Start date
A

AD Carvajal

In the following spreadsheet, I need to count the number of times "y" appears
in the Guest column when B appears in the Site column. Is there any way to
do this with one formula

Site Guest
E n
E n
E n
E n
E n
E n
E n
E n
E y
E n
B n
B n
B y
B y
E n
E n
E y
E y
E n
E n
A n
A n
A y
A y
A n
 

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

Scrabble Value calculation for Welsh words 0
calculate total items meeting criteria in range with multiple shee 2
IF statement in macro 4
Macro_AND function 2
calculate total number of items that meet 2 over multiple sheets 5
if query2- urgent requried 1
COUNTING TEXT VALUES GIVEN MORE THAN ONE ARGUMENT. 2
Sumproduct query 4

Back
Top