How do I count a value if another field = a specific value? Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to count a specific value only if another column has a specific
value.

If column B=blue AND column I=App then count it.

I'm sure it's simple but I can't seem to find a function to make it work...
and I can't get the nested functions to work either...

April
 
You must log in or register to reply here.

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

Count Unique Values in 1 Column based on Date Range in another Column 28
need help on either doing a loop and counting specific values orusing subtotal function 2
Count values, excluding duplicates and specific values 2
Nesting SUBTOTAL with SUMPRODUCT? 0
Count Unique Values 4
count unique values in one column for a set value in another col. 2
How do I count # of cells with same value other column? 4
Counting values in column B in condition of A 2

Back
Top