Hello Everyone,
I am trying to make a tracker for daily tasks that are being done by instructors in my school. In the excel sheet, I have attached a rough draft of what I have started. In Column B I have a selection of what task they are doing for the day (i.e. 105 106 402 etc) Column C I have whether the individual will be doing the safety task for the day. The issue I am having is in Column D I want whatever MIR I select to add up to 8 and if I select Y for safety I want it to add up to 8. The formula I have adds the safety but only adds some of the MIR tasks. Any help would be appreciated.
V/r,
David
Hello David,
Check if this formula gives what you want. If you want the 8 as text, just wrap quotation marks around it.
=IF(OR(ISNUMBER(B4),C4="Y"),8,FALSE)
Br,
Anders
Thank you Anders this is exactly what I needed.
