LinkBack URL
About LinkBacks
If vacation is in column A anywhere, I need K21 to format to add all vacation time used in a time period, after it is added weekly in column K.
If vacation is in column A anywhere, I need K21 to format to add all vacation time used in a time period, after it is added weekly in column K.
Try this:
=SUMIF(A4:A15,"Vacation",K4:K15)
Please update your forum profile with your current version of Excel.
Last edited by AliGW; 12-09-2019 at 06:31 PM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
copied and pasted. Did not calculate.
Yes, it does calculate in your spreadsheet.
Last edited by AliGW; 12-09-2019 at 06:38 PM.
Thank you very much. It did work after I removed the drop box that I was manually selecting hours.
As usual I stand corrected AliGW.
Please note that this is not a question about conditional formatting, so you should not have used CF in your thread title (it's a bit misleading).
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks