Mar 14 2017
08:15 PM
- last edited on
Jul 25 2018
09:28 AM
by
TechCommunityAP
Mar 14 2017
08:15 PM
- last edited on
Jul 25 2018
09:28 AM
by
TechCommunityAP
Hi, I'm sure excel can do this I just can't figure out how.
I have a spreadsheet which has department names in the first column and dates across the top row. I have shaded the cell relevant to when each unit is scheduled to start a piece of work. How do I add a formula at the top of the worksheet to count which units are overdue to start work?
Thank you
Mar 15 2017 05:10 AM
There's no standard formula you can use to count shaded cells
The easiest solution would be to type a 1 in each cell you that corresponds to the start date
Then at the top of each date column do a sum of the column of 1s
Can you send a screenshot or attach a copy of the file if I'm not quite understanding what you're trying to do.
Thanks
Wyn