willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 871
- Office Version
- 365
- Platform
- Windows
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 it by referencing a range of cells for: History, Consumables, Quarantine and R&D / Testing. The Range of cells would be Z16:Z19.
Is there any way to do this?
Something like: ="Open WorkOrders: "&SUMPRODUCT(COUNTIFS('WO Report'!$E:$E,"<>Z16:Z19",'WO Report'!$E:$E,">""",'WO Report'!$S:$S,$B$12:$G$12)) Although I know this is not correct....
Maybe add Z20 as a blank to get rid of: 'WO Report'!$E:$E,">""" Section if possible??
Thank you very much to anyone who can help with this
Carla
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 it by referencing a range of cells for: History, Consumables, Quarantine and R&D / Testing. The Range of cells would be Z16:Z19.
Is there any way to do this?
Something like: ="Open WorkOrders: "&SUMPRODUCT(COUNTIFS('WO Report'!$E:$E,"<>Z16:Z19",'WO Report'!$E:$E,">""",'WO Report'!$S:$S,$B$12:$G$12)) Although I know this is not correct....
Maybe add Z20 as a blank to get rid of: 'WO Report'!$E:$E,">""" Section if possible??
Thank you very much to anyone who can help with this
Carla