Results 1 to 8 of 8

frequency and sumproduct

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-27-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    113

    frequency and sumproduct

    Im trying to use sumproduct to match by 2 different criteria

    criteria
    1) store #
    2) invoice amount

    to get the an order #

    =SUMPRODUCT(--($E$2:$E$1508=A2),--($G$2:$G$1508=B2),--($F$2:$F$1508))

    however....im struggling with to add logic (see highlight in yellow)

    1)i was wondering if frequency can be used so it does not double count (see highlight in red)
    (ie. invoice $36 is listed twice with store # 007....the sumprod will list the order # twice, however it only appears once in column F)

    2) if invoice is listed twice $36 in column B, then check to see in column E & G is item is listed once under $70....is yes, then assign the code as $70/2 = $36


    i would be very very grateful if someone can pls help!!

    thxing u in advance.....
    Attached Files Attached Files
    Last edited by step_one; 12-16-2011 at 05:53 PM.

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