Did you press Ctrl-Shift-Enter Pascale?

You could use a non-array SUMPRODUCT formula

=SOMMEPROD(--($B$2:$B$54=$I74);--($I$2:$I$54=$G$74);K$2:K$54)+J74

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Pascale" wrote in message
...
Hello,

Happy new year to the team at excel! Please, Keep doing great work with
the
help you are giving us it is much appreciated.

I would like to know why this formula keeps giving me the error (VALEUR)
My
computer is in french!!!

=SOMME(SI($B$2:$B$54=$I74;SI($I$2:$I$54=$G$74;K$2: K$54;0)))+J74

I would like to send you the complete file but I dont know how...

Thank-you!