Hi everyone,
I am a little out of my depth on this one so would really appreciate some help with the attached basic CRM sheet.
At the moment we are keeping a running total of leads / conversion rates etc which you should see at the bottom of the grid.
What I would like to add it the same next to this but for the previous 7 days, a summary u think would be :
Quote Past 7 Days ( CountA in column J only if in 7 day range )
Conversions Past 7 Days ( countif " converted "in column m only in past 7 days range )
I would be able to figure the rest I hope![]()
Sorry if this is obvious but its a little beyond me atm and really appreciate some support
Bookmarks