workorders

  1. willow1985

    Shortening a long SUMPRODUCT/COUNTIF formula

    Hello, I have the following formula: ="Open WorkOrders: "&SUMPRODUCT(COUNTIFS('WO Report'!$E:$E,"<>History",'WO Report'!$E:$E,"<>Consumables",'WO Report'!$E:$E,"<>Quarantine",'WO Report'!$E:$E,"<>R & D / Testing",'WO Report'!$E:$E,">""",'WO Report'!$S:$S,$B$12:$G$12)) I am looking to shorten...
    • willow1985
    • Thread
    • $b$12$g$12 &sumproductcountifswo range report$s$s workorders
    • Replies: 3
    • Forum: Excel Questions
  2. C

    Assigning work to people by day

    Good afternoon, I download a spreadsheet once a month that contains workorders for a given department. The workorders are divided up by responsibility and by the activity code. We then assign the correct employee and shift to the workorder (manually right now). In Power query I have the table...

We've detected that you are using an adblocker.

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.
Go back
Back
Top