Counting on 2 criteria
 

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


--
Richie

Counting on 2 criteria
 

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

On Jul 10, 3:04*pm, Richie wrote:
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

--
Richie

Counting on 2 criteria
 

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

--

"Richie" wrote in message
...
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


--
Richie