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