In K4 on "Display Sheet":and copy downFormula:![]()
=COUNTIFS('PCC Call Data'!$F$3:$F$458,"<>",'PCC Call Data'!$J$3:$J$458,H4)
In K4 on "Display Sheet":and copy downFormula:![]()
=COUNTIFS('PCC Call Data'!$F$3:$F$458,"<>",'PCC Call Data'!$J$3:$J$458,H4)
Best Regards,
Kaper
THANKS KAPER! !
Lastly, I want to (without a pivot table) be able to select a month's worth of data (using a dropdown list and an IF statement) and display the practice-specific data on the 'Display Sheet". The data would come from the 'PCC Call Data' sheet.
Example: Select "June" from dropdown list and the practice-specific data on the 'Display Sheet' will show the data only for June (the months are separated in the 'PCC Call Data' sheet)
I realize this is a large endeavour. Thank you for any possible he
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks