I go around in a circle:
I have a row of headings in the range A1:NA1 where the headings are dates from 1 Jan to 31 Dec, i.e. 365 days
I want to use COUNTA to count a number of cells in a range that are not empty, i.e. in the row A2:NA2. This range includes a "P" in every cell below the corresponding date that a person was present.
However, whereas the start of the COUNTA range would be $A$2, I want the end of the range to correspond with the actual system date of the computer. For this I thought to use NOW.
But, whereas I can find the cell reference for NOW (in row 1), I would need something like OFFSET to find the relevant cell reference in row 2 for the COUNTA function to calculate. If I get this right, then every day the spreadsheet would tell me how many "P" days there were from 1 Jan to the present date - on every new day
And right here I get lost so much that when I turn around I walk into myself .
Can a good soul out there please point me in a direction?
Appreciated.
Bookmarks