Sumproduct to multiply by a cell value

[Merlin54k]

I need to multiply the value located in Cells StampsJ2:J9 by


Stamps!$G$2:$G$9=Sheet2!B2


=SUMPRODUCT((Stamps!J2:J9)*(Stamps!$G$2:$G$9=Sheet2!B2))

Sheet2!B2 <--------- the value in this cell can change.

[Gearcutter]

Hi merlin,
You will have to change values in Stamps Col G from to match what you have in B2 on sheet 2 . eg "L14" becomes "Local 14" then use the fomula:

=SUMPRODUCT(--($G$2:$G$8=Sheet2!B2),--(Stamps!$J$2:$J$8))

that I believe will give you the answer that you are after.


Regards Howard