Hello, I used a simple formula as: =SUMPRODUCT(--(Result="OK"),Sheet2!A1:A10). Here, the name 'Result' is a named range for Sheet1!A1:A10. The formula is typed in Sheet 3.
It worked nicely in Excel 2010, but does not work (#N/A) in Excel 2003. Don't know why?
Works OK for me in Excel 2002.
Do you have any #N/A errors in either of the ranges?
An alternative is to use SUMIF...
=SUMIF(Result,"OK",Sheet2!A1:A10)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks, Tony. I got it working now
Good deal. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks