This one hopefully is my last one. I need Excel to look up a region, and then the type of job which I have done. Then the final column I need it to total the number of hours. So my CountIFS bit works, but as soon as I add the formula to total the hours up from I11 to I164 it just wont work...
Its a difficult one to explain but I have spent hours trying to work this out and I have literally hit a brick wall. Not sure how to upload the spreadsheet to make it easier to explain so apologies. I have inherited this and I just dont know how to work this out and I know what I want to work...
Hello Experts,
I need help for creating an Open aging incident report. I’m part of Service desk and my team lead has assigned me this task.
I have pulled raw_data of incidents from ServiceNow a ticketing tool that we use. Below is how the raw data looks. Raw data generated on 4-Aug-2017...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.