I'm working on a company project where I've been asked to use the sumifs function. The issue I got is that I need to combine multiple sheets with different criteria. At this moment, all I've is a Master sheet where I've details about the columns of different worksheets, and the other 3 sheets contain data with all categories different from the other 2 sheets.
For example-
Master Sheet has the date, caller id of employees(for the Phone Call sheet), email sender id(for Email sheet), work_id (for the Schedule Sheet).
Phone Call sheet has call time, caller id, and their date.
Email Sheet has the email sender id, number of emails, date and time.
Schedule Sheet has work_id for employees, hours spent on calls, and hours spent on email.
And now, I'm left with combining all the worksheets so that I could work on the Pivot tables for further data analysis.
For example-
Master Sheet has the date, caller id of employees(for the Phone Call sheet), email sender id(for Email sheet), work_id (for the Schedule Sheet).
Phone Call sheet has call time, caller id, and their date.
Email Sheet has the email sender id, number of emails, date and time.
Schedule Sheet has work_id for employees, hours spent on calls, and hours spent on email.
And now, I'm left with combining all the worksheets so that I could work on the Pivot tables for further data analysis.