Try...

=SOMMEPROD((INDIRECT($N$28)=$C31)*(INDIRECT($P$28) =$D31))

Note that the formula does not need to be confirmed with
CONTROL+SHIFT+ENTER. Confirm with just ENTER.

Hope this helps!

In article ,
"christophe meresse" wrote:


Hi

When I write my function {=sommeprod((toto1=$C31)*(tutu1=$D31))}
I've the correct result : correct number of match in relation with my
demands in C31 and D31
toto1 is Range(E8:E78) of another sheet
tutu1 is Range(F8:F78) of another sheet

But when I write {=sommeprod((N28=$C31)*(P28=$D31))}
It doesn't work...even I've written toto1 in N28 and tutu1 in P28
What's the problem?