Where am I going wrong in this SUMIF formula?
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.
Best Answer

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} )
Answers

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} )

Thank you! I thought I had tried that combination but I must not have!
Help Article Resources
Categories
Check out the Formula Handbook template!