Formula problem

[Pascale]

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!

 

[Bob Phillips]

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)

 

[Bernard Liengme]

Are you completing this by using SHIFT+CONTROL+ENTER not just enter?
In the formula bar the formula should display within curly braces
{your-formula}

Why not use SUMPRODUCT (SOMMEPROD en francaise). This is completed with a
simple ENTER

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

For more details on SUMPRODUCT
Bob Phillips
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
J.E McGimpsey
http://mcgimpsey.com/excel/formulae/doubleneg.html
best wishes