Hi
I have a CRM spreadsheet where I am trying to create an historical calendar record of all productivity and sales per calendar month.
This is where I have got to:
=SUMPRODUCT(--('Communication Log'!$A$6:$A57<=B44),--('Communication Log'!$A$6:$A57>=A44),--('Communication Log'!$I17:$I57=1))
but i get #VALUE
Also tried
=SUMPRODUCT(('Communication Log'!$A$6:$A57>=DATE(7,1,2019))*('Communication Log'!$A$6:$A57<=DATE(7,31,2019))*('Communication Log'!$I17:$I57=3))
but I get #N/A
I am working on the overview tab. Column A is the start of the date range (1/7/2019) and column B is the end (31/7/2019)
Data is held on the Communication Log sheet with the dates of entry in column A: and the criteria (type of productivity) in Column I eg -1=call, 2= email, 3 = meeting etc.
The question i am trying to answer is how much productivity, per type, was carried out between 1/7/19 and 31/7/2019.
Having looked on line I have tried various options eg: with " " either side of <= and replacing -- with * but errors appear.
Can anyone guide me on this?
Ruth
Bookmarks