how do I count occurrences of multiple conditions

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

Guest

What I am trying to do is count the number of occurances that meet two
criteria. Specifically I need to count how many times the initials CB are in
A3:A306 and in the same row however range Q3:Q306 the cell is blank. I am
running into problems with the last criteria being blank. Additional the
value or lake thereof in Column is derived by a formula that allows the
sumation of cell if the specifed cell is not blank ie.'=IF(ISBLANK(K282),"
",SUM(L282:T282))
 
You have lost me exactly what you are wanting to do. That being said to count
with multiple criteria you probably want something like...

=sumproduct(--(A3:A306 = "CB"), --(Q3:Q306 = ""))
 
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 cells in a table that meet multiple criteria 1
Counting cells with multiple criteria 3
Counting Occurrence of a Value within Cells 1
Counting in multiple column 2
Count and Sum of cells if conditions fulfilled 12
Counting with multiple matching criteria 11
Counting Multiple Text Cells 4
If Condition Confusion 3

Back
Top