I am making a schedule on excel and I using =IFERROR(VLOOKUP(M3,Friday, 8,FALSE),0)+IFERROR(VLOOKUP(M3,Saturday, 7,FALSE),0)+IFERROR(VLOOKUP(M3,Sunday, 6,FALSE),0)+IFERROR(VLOOKUP(M3,Monday, 5,FALSE),0)+IFERROR(VLOOKUP(M3,Tuesday, 4,FALSE),0)+IFERROR(VLOOKUP(M3,Wednesday, 3,FALSE),0)+IFERROR(VLOOKUP(M3,Thursday, 2,FALSE),0)+P3
To count peoples name and report back how many times it finds them on a friday-thursday schedule. It counts the name and times it by a specific hours for which that position is slotted for.
The problem is that it only counts the name once in a column. For example
John is working slot A 1400-1800 HRS (SHEET1 CELL G4)
and John is also working Slot C 1800-2200 (Sheet1 Cell G7)
It only counts slot A and ignores slot C
I need it to count both.
15 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hello, I’m an Excel expert and I would like to help you with your formulas. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.
I can work on it sir, I am good in using advance formulas. do let me know over chat. Relevant Skills and Experience MS Excel Proposed Milestones $30 USD - Upon Completion
I have experience in that field according to my previous work as teacher at multinational school where i taught using Microsoft Office. Relevant Skills and Experience ICDL Proposed Milestones $25 USD - Excel