Hi,
Looking for a formula to count all occurrences in a column determined by match function on date in header.
I have names in column a, row 1 contains dates and row 2 sub headers booked and arrived. I would like to calculate how many y appear in a column based on the column determined by the match on the date in row 1 for booked and arrived and summarised i5 to k7 in a table.
Can someone please help?
Many thanks
Bookmarks