Ask Experts Questions for FREE Help !
Ask
    kvinay_00's Avatar
    kvinay_00 Posts: 36, Reputation: 1
    Junior Member
    		  
    #1

    Jun 24, 2009, 11:31 PM
    Getting error in using SUMPRODUCT
    I have a sheet linked to a cell containing SUMPRODUCT formula (like "=SUMPRODUCT(--(dealer_List=A6),(claims_recd),--(Data_List>=$B$2),--(Data_List<=$D$2))".

    "claims_recd" is NAME i have given to a column and have some basic IF formula for gettng value.

    I am getting "0" value in the cell which contain SUMPRODUCT formula even if there is a number greater than 0 in the cells. If I type numbers manually, I get the required result in the cell with SUMPRODUCT formula.

    Can sombody help please?

    Thanks a lot.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jun 25, 2009, 02:04 AM

    The formula looks good. Are the named ranges Data_List and Dealer_List both the same number of rows deep?

    Post up a sample worksheet with your formula in it and misbehaving, point out where that is and I'll take a look.
    kvinay_00's Avatar
    kvinay_00 Posts: 36, Reputation: 1
    Junior Member
    		  
    #3

    Jun 25, 2009, 04:22 AM
    Thank you for your reply.
    I was able to catch the error - it was in the assigning of name.
    Now it is working all right.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

IE printing error: res://ieframe.dll/preview.dlg error [ 15 Answers ]

I have seen about a dozen posts on different Web sites regarding this error. The most common fixes are related to an individual work station. We are experiencing this problem with our Web site and everyone accessing it is unable to print pages that are within frames. I tried the fixes on my...

Oracle Error 12560:tns Protocol Adapter Error [ 3 Answers ]

Hi, Whenever I try to log in using SCOTT/TIGER userid, I get the error "ORA ERROR 12560:TNS PROTOCOL ADAPTER ERROR". I tried starting the listener from administration-> services, but still the problem persists. Can you please suggest a solution?

Printing Error-Script Error [ 1 Answers ]

When I try to print a window pops up: Internet Explorer Script Error Line:1174 I have tried several things: Quick Restore, checked Script debugging box.

View more questions Search