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.
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.
Last edited by VBA Noob; 10-01-2008 at 03:44 PM. Reason: Poorly titled.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks