Hi Hui
Thank you very much with this it work a treat, just another question could i use your formula for the red and green count and if so what would i need to change.
Kind Regards
Hi Just wondering if this is possible, I have a Red ,Amber, Green Status and i would like to have an overall picture of all 3 status.I can get the red and green to add up but cannot figure away to include the amber status. See attached
kind regards
Thank you Marc and Belleke for your time and response in helping me out. I was searching for a solution late last night and found this Example see attached that would help me out. But Im struggling to work out why I can not get it past row 18 when I add more Tasks, but I like the Idea tick...
Hi all looking for some help with my sheets, I have 2 sheets , Sheet 1 is the Task List where I need to put a tick in column "A" then this transfers the row to "Site Schedule tab"". I also want to be able to remove the tick from sheet 1 in case i make a mistake and this removes the data from the...