Mattdim805
New Member
- Joined
- Dec 11, 2013
- Messages
- 11
My Google sheet can be referenced here.
On the 2021 Openers tab, I need to create a formula that will allow me to count the total amount of leads associated with a specific person within a specific month, referencing the data on the 2021 Lead Data tab.
Formula criteria to consider:
i.e. i.e. Cell '2021 Openers'!C6 needs to count cells that match the adjacent name in '2021 Openers'!A6 to '2021 Lead Data'!E:E, the month of April in '2021 Lead Data'!B:B, and "Won Lead" in '2021 Lead Data'!C:C.
Thanks in advance for the help!
On the 2021 Openers tab, I need to create a formula that will allow me to count the total amount of leads associated with a specific person within a specific month, referencing the data on the 2021 Lead Data tab.
Formula criteria to consider:
- The Leads column should only count leads for the adjacent names that match the Lead Opener column, that are in the month of April and have a Lead Status of Lost Lead, Won Lead, Working, and Start a Quote.
- The Policies column should only count leads for the adjacent names that match the Lead Owner column, that is in the month of April, and have a Lead Status of Won Lead.
i.e. i.e. Cell '2021 Openers'!C6 needs to count cells that match the adjacent name in '2021 Openers'!A6 to '2021 Lead Data'!E:E, the month of April in '2021 Lead Data'!B:B, and "Won Lead" in '2021 Lead Data'!C:C.
Thanks in advance for the help!