Results 1 to 2 of 2

sun product issue

Threaded View

jw01 sun product issue 05-26-2011, 06:28 PM
Cutter Re: sun product issue 05-26-2011, 06:33 PM
  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

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