Hello!
I've been tasked with creating a spreadsheet to track my company's sales leads.
I have all of it completed besides one section.
I need to create a formula to show the amount of sales for each sales person for each month and to have it populate on the third tab "Jan".
I have attached a screenshot of the main tab. Please ignore the song lyrics under cust tab :b I was just plugging in random info to test my formulas.
I have completed the year to date summary for each lead generator, however I cannot figure out how to get their monthly sales.
I tried a few different ways but always ended up with a ref error
I tried this formula and I get a dollar amount but it isn't correct at all
=SUMPRODUCT(--( $B15='Lead Log'!$E$2:$E$984),(--(1=MONTH('Lead Log'!$O$2:$O$984))),('Lead Log'!$J$2:$J$984))
Bookmarks