Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
christophe meresse
 
Posts: n/a
Default


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem using sumproduct Hiughs Excel Worksheet Functions 4 March 5th 05 11:28 AM
Problem with sumproduct and month=1 bobh727 Excel Worksheet Functions 6 February 15th 05 07:13 AM
Another Sumproduct & #N/A problem Dave Davis Excel Worksheet Functions 3 January 10th 05 03:59 PM
SUMPRODUCT Problem Mestrella31 Excel Discussion (Misc queries) 2 December 21st 04 07:01 PM
SUMPRODUCT problem Jane Excel Worksheet Functions 3 November 8th 04 11:58 PM


All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"