Counting on 2 criteria

  • Thread starter Thread starter Richie
  • Start date Start date
R

Richie

Hi,

I am trying to count the number of entries in a spreadsheet where i have 2
criteria.
One column contains the dept name eg "Sales" and another is a score which is
calculated from a formula.

I've tried Countif's and sum products but with no luck.

=SUMPRODUCT((‘live risks’!b2:b100="Rollout")*(‘live risks’!n2:n100=8)) does
not work.

I have tried using an AND command with Counif, but with no luck.

Thanks
 
Are you sure those cells containing Rollout do not have any spaces at
the end? Could your numbers in column N actually be text values that
look like numbers? Here are some variations you could try:

=SUMPRODUCT((LEFT(‘live risks’!b2:b100,7)="Rollout")*(‘live risks’!
n2:n100=8))

=SUMPRODUCT((LEFT(‘live risks’!b2:b100,7)="Rollout")*(‘live risks’!
n2:n100="8"))

Hope this helps.

Pete
 

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

Multiple Criteria Date Count formula 1
Count multiple criteria 7
count if for blanks with 'or' 3
Sum total using Sumproduct if two criteria met 5
help counting 2
Counting with multiple matching criteria 11
count number of dates in a row of cel before or after a variable d 5
COUNT based on 2 criteria 14

Back
Top