Where am I going wrong in this SUMIF formula?

Kelly Gabel

Here is my formula: =SUMIF({Shell Projects - High Level Tracker CP}, Wholesaler@row, {Shell Projects - High Level Tracker Owner})

I'm trying to say, if the "Owner" on another sheet equals the Wholesaler on the row on my sheet, then sum the CP on that other sheet.

The formula isn't throwing any errors, but is return an answer of "0" which is not correct.

KT_H

Hi Kelly,

You have the sum range and the criterion range flipped, try this.

=SUMIF({Shell Projects - High Level Tracker Owner}, Wholesaler@row, {Shell Projects - High Level Tracker CP} )

KT_H

Hi Kelly,

You have the sum range and the criterion range flipped, try this.

=SUMIF({Shell Projects - High Level Tracker Owner}, Wholesaler@row, {Shell Projects - High Level Tracker CP} )

Kelly Gabel

Thank you! I thought I had tried that combination but I must not have!