Attendance sheet

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top