Looking to VLOOKUP into one data sheet to find
- a sales rep name where the sales stage is contracted and sum up the Estimated Value field, which sums up any dollar amount in the (estimated value) field. End result is to show a sales rep and how much they have contracted to close via a dollar amount.
My formula example:
=COUNTIFS({Sales Stage}, ="FU-6", {Sales Rep}, ="Phil", {Est Value}, = "???")