Forum Discussion
Help. Formula pLease
I have an attendance sheet that is marked daily by w, ae, and au. I need the w's to add and change to the right number when i highlight a specific day.
What formula will help with that?
- Hello ChantelleMyia
As it is, your question is very difficult to understand. Could you add some example gifs, screenshots or an example workbook with more description of the problem?
If you can show exactly what is changed, what the "right" number is and what you expect to happen when highlighting a day, someone will be able to guide you to the right answer.So I need to be able to click on the dates across the top and the different number correspond to the color box. is that possible?
Thanks for adding the image. I'm afraid it's not clear exactly what you want to do.
You said "click on the dates across the top"
Do you mean you want to select cell J5 (for example)?
After you have selected a date, what do you want to happen? Do you want to show a count of rows for that date that have each of the codes mentioned?
So:
1. Click on the date header (for example: cell J5)
2. 13 shows in the green box at the top, 5 in the blue box and 5 in the red box
Can you confirm that's what you want to happen?
What are the columns G, H and I for? Are they a sum of all of the codes for the whole month?
