Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() Thank you for your help, it works very good !! "christophe meresse" a écrit dans le message de ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem using sumproduct | Excel Worksheet Functions | |||
Problem with sumproduct and month=1 | Excel Worksheet Functions | |||
Another Sumproduct & #N/A problem | Excel Worksheet Functions | |||
SUMPRODUCT Problem | Excel Discussion (Misc queries) | |||
SUMPRODUCT problem | Excel Worksheet Functions |