Sum variable values based upon list lookup

[Jeffy]

Hello,

I was searching the web for help with my issue and saw that SumProduct could be of assistance, but the tutorial didn't go far enough.

In the attached file, I'm trying summarize totals in column C of the "Data" tab.

If the sites in "Data" column "A" are listed in "Lookup" column "A," then I want relevant values in "Data" column "B" to be multiplied by 125% and totaled in "Data" column "C".

If the sites in "Data" column "A" are NOT listed in "Lookup" column "A," then in "Data" column "C" return the same values as "Data" column "B."

[jtakw]

Hi,

If I understand correctly, use this in Data C2:

Please Login or Register  to view this content.

See attached.

[jtakw]

You're welcome, glad it worked for you and glad to help, thanks for the rep.