Summing List Entries 2

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

Guest

Thanks Guys!!!

That works great!

Is it possible to refine this count further by only returning a count if a
condition in another column is also met? For example, say I have my drop
down lists in column A and in column B there are only "1"s and "0"s or "YES"
and "NO". Can I return a count for the initial 5 possibilites only if they
are paired with a "1" or "YES"? In other words, if A1 contains "C" and B1
contains "1", count 1 for "C" but if A1 contains "C" and B1 contains "0" or
is blank return a count of 0 for "C"

Sorry I'm sure I could have worded this better, hope it makes sense.

Cheers!
 

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

need formula returning a blank cell 4
Event Counter 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
If/Then formula using ranges 5
And then there were ZEROs... 7
Complications with formulas 1
Pivot Table Calculated Field - Sum/count 1
if statement 2

Back
Top