Recent content by ConfigQueen

Thanks Empip. I have realised I am using an array function however it is the date referencing that I am failing on. Will now try using named cells for this. Playing but not learning what I want to know :( Love the pearson site.

Help with a macro please. I am trying to count the number of appointments per resource on a weekly basis. In have a number of regional worksheets with a named resource column and a appointment date column in each. As COUNTIF does not support 3 dimensional referencing I have thought of...