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.....

Hi,

What is the ultimate end result you're aiming for? Maybe SUMPRODUCT is not what you should be using.

For instance does the attached with a pivot table on sheet2 help?

Originally Posted by step_one

.....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 don't think I follow this. For the example given what results do you want to see in C39 and C40?