Jessb9187✭✭✭✭

那工作!非常感谢。

Here's another screenshot of that sheet. So that club # could have a few numbers in there instead of just 1 number. If I can filter through that to say, "show me the revenue number for a cell that contains these specific numbers", that's what I'm trying to do. I hope that makes sense.

Definitely. I need the MRGP amount to populate in my sheet if this sheet contains the same numbers in the club# column as what's found in my sheet.

耶!的second one works! Thank you for your help!

So I figured it out. Apparently you need a SUMIFS not a SUMIF formula. Updated formula: =SUMIFS({KPI: Visit Types &Days Onsite Remainder 20 Range 2}, {KPI: Visit Types &Days Onsite Remainder 20 Range 1}, "Conversion")

It was the same sheet. I'm not sure why the reference for the criteria was pulling a different name. I've updated my formula and now it's pulling the same sheet name at least. This one, gives me an incorrect argument set. =SUMIF({KPI: Visit Types &Days Onsite Remainder 20 Range 2}, {KPI: Visit Types &Days Onsite Remainder…

Also, I might mention that I changed the formula at the tail end to show if it's greater than 9999 to show "Key Account". Because I had a < for every number except the 10000, when the cell was populated with 10,000 exactly it was showing as blank. Final Formula: =IF([Notification Booked Billing Amount]@row = 0, "",…

A few formatting issues, specifically with commas inside of the numbers and the $ signs. I think they were unnecessary in the formula but I assumed they had to match exactly what was being populated in the cell but I guess that's not the case!

I got it! Here's my updated formula: =IF([Notification Booked Billing Amount]1 < 1000, "SMB - LOW", IF([Notification Booked Billing Amount]1 < 3000, "SMB - HIGH", IF([Notification Booked Billing Amount]1 < 5000, "MID Low", IF([Notification Booked Billing Amount]1 < 10000, "Mid High", "Key Account"))))

Hey Nic, That doesn't seem to fix the issue. Any other ideas?