Hello,
I am currently using the following formula to calculate how many students had a certain type of meeting, it works fine unless you have blank cells where a students name has not been entered. I was wondering if there was a way to adapt the code so it skips blank cells? In my document I have 2 unique student names that have had the meeting type but the formula is only stating one due to the blanks as far as I can see.
I hope someone can help!=SUM(IF(FREQUENCY(IF('[HDC Outreach Tracker.xlsm]Sam Vinten'!$D$7:$D$15='[HDC Outreach Tracker.xlsm]LOCKED'!$D$5,MATCH('[HDC Outreach Tracker.xlsm]Sam Vinten'!$B$7:$B$15,'[HDC Outreach Tracker.xlsm]Sam Vinten'!$B$7:$B$15,0)),ROW('[HDC Outreach Tracker.xlsm]Sam Vinten'!$B$7:$B$15)-ROW('[HDC Outreach Tracker.xlsm]Sam Vinten'!$B$7:$B$15)+1),1))
Thanks
Jamidd
Bookmarks