xlhelp15
Board Regular
- Joined
- Sep 12, 2014
- Messages
- 113
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
Hello Experts - Would need assistance on the below.
Have tried SUM+COUNTIFS, COUNTIFS+INDEX, MATCH but didn't get as what i expected.
Would need to provide the output based on Date + Core + Processor + Present indicates as P and so on.
Attached the attendance tracker for your easy reference.
Based on Batch, Role - Date - it should count P, PL, ML and UPL to the respective Core & Ramp batch.
Have tried SUM+COUNTIFS, COUNTIFS+INDEX, MATCH but didn't get as what i expected.
Would need to provide the output based on Date + Core + Processor + Present indicates as P and so on.
Attached the attendance tracker for your easy reference.
Based on Batch, Role - Date - it should count P, PL, ML and UPL to the respective Core & Ramp batch.