Counting on 2 criteria

[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

 

[Pete_UK]

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

 

[PCLIVE]

Your syntax appears correct. What is the result that you get...and what
should it be?