+ Reply to Thread
Results 1 to 2 of 2

sun product issue

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,233

    sun product issue

    Hello

    Im having a hard time with the sum product rule. im not sure at all why its giving me an error.

    here is my formula:

    =SUMPRODUCT(--('NAR Performance'!$D$14:$D$185=Sheet1!C7)*--('NAR Performance'!$H$146:$H$185=Sheet1!A9))

    where range D = SE, SSE
    C7 = SE

    where range H = country i.e. CA, US
    A9 = CA

    it's giving me NA error.

    can someone pls help me out. I have highlighted it in red on the attached worksheet. thx you so much and pls!

    basically, im trying to count how many of sales ppl called "SE or SSE" are located in the states or canada.
    Attached Files Attached Files

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: sun product issue

    In C9 you have
    =SUMPRODUCT(--('NAR Performance'!$D$14:$D$185=Sheet1!C7)*--('NAR Performance'!$H$146:$H$185=Sheet1!A9))

    Note the mismatched ranges you have $14 in first segment and $146 in the 2nd segment - remove the 6

    I would use:

    =SUMPRODUCT(('NAR Performance'!$D$14:$D$185=Sheet1!C7)*('NAR Performance'!$H$14:$H$185=Sheet1!A9))


    BTW - you should correct the spelling mistake in your title (to assist future searchers)
    Last edited by Cutter; 05-26-2011 at 07:14 PM. Reason: Added BTW

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1