Hi,

I am relatively new to excel so please forgive me id this question is very basic.

I am creating an attendance sheet that counts attendance after a specified date. I am using the following formula.

=COUNTIFS(G57:BX57, "X", G1:BX1, "4/25")

Where the dates are on the first row G1 To BX1

However I would like to protect the sheet from the users but allow them to change the reference date manually without using this string so I have tried

=COUNTIFS(G57:BX57, "X", G1:BX1, "C57")

Where C57 would be the reference date entered by the user.

But it returns a 0 no matter what I try instead of what i need.

I was wondering if there was anything that I am missing or if I have to try something else. Thank you.

Got the answer from another forumn.

""&C57