That formula should work fine if you array enter it, that is, hit
Ctrl-Shift-Enter after typing it not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"dancab" wrote in message
...
Hi,

I try to get a formula that search in a range A1:A5 which elements are =
100% and base on that search in B1:B5 which elements are = " P1" and
return
the number of elements that meat this condition.

This is the formula that I try to use and it does not work.

=SUM(IF($A1:$A6=C1,IF($B1:$B6=$D1,1,0)))

A B C D

1| 100% P1 100% P1
2| 100% P1 80% P2
3| 80% P3
4| 100% P5
5| 100% P2
6| 30% P1

What I spect is 2.

I am big time stuck and I have presentation this week :(

Thanks for your help