A
alfredpirovits
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.
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.