Hello,
First post. This is a messy one. We are using this to track renewals. Once our renewals are done on the program, we change the status to "Complete". Once in that status, I want to find a way to have each sales reps totals, added together to see their renewal rates. I was using this formula, "=SUMIF(H3:H50,"*Kendra*",I3:I50)", with the information at the bottom, but I cannot filter this. Also, there are 4 different columns where her name could show up, so I didn't know how to avoid having her name at the bottom of each column.
Does this make any sense at all?
In a perfect world, if the status cell is "Complete" than I'd like to have any instance of the reps name, be found and added to one location with their name, with all renewal stats. a "Kendra, #, #, %" for the entire sheet.
Please help.
Josh
Bookmarks