Attendance tracker

[alfredp666]

Other recipients:



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.

 

[s hal]

Instead of ">C57" try ">"&C57

 

[alfredp666]

Thank you. Worked perfectly!!!

 

[s hal]

No problem! The reason what you did was not producing the result was because you always were comparing your value to being greater than C57 which is a text string instead of greater than "the value of cell C57".