The same formula is needed for 3 sets of columns on sheet ‘STATS’
Sheet ‘STATS’ C21:C32 & D21:D32 are under the heading in C19 as APPT
Those 2 columns and the adjacent TAKEN & SOLD heading columns are the ones where the formula will need to populate.
So to cover how the formula needs to work, let me give an example:
From the ‘LEADS’ sheet, when a date is entered into J6:J1005 which falls under the APPT heading, a count should populate in ‘STATS’ C21:C32 or D21:D32 based on the input on ‘LEADS’ I6:I1005 and the date entered to fall under the correct month.
The same is needed for the TAKEN header on STATS F21:F32 & G21:G32
As well as SOLD header on STATS I21:I32 & K21:K32
This would be a big help
Bookmarks