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
 
Back
Top