willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 931
- Office Version
- 365
- Platform
- Windows
Hello,
was wondering if anyone could help me with the below formula. Is there a more elegant way of writing it rather than adding each additional section?
I want the formula to count E:E if it matches Z2, and if S:S matches B12, C12 and D12. Would this be some sort of Countifs/And formula?
=COUNTIFS('WO Report'!$E:$E,Z2,'WO Report'!$S:$S,$B$12)+COUNTIFS('WO Report'!$E:$E,Z2,'WO Report'!$S:$S,$C$12)+COUNTIFS('WO Report'!$E:$E,Z2,'WO Report'!$S:$S,$D$12)
Thank you for all of your help
Carla
was wondering if anyone could help me with the below formula. Is there a more elegant way of writing it rather than adding each additional section?
I want the formula to count E:E if it matches Z2, and if S:S matches B12, C12 and D12. Would this be some sort of Countifs/And formula?
=COUNTIFS('WO Report'!$E:$E,Z2,'WO Report'!$S:$S,$B$12)+COUNTIFS('WO Report'!$E:$E,Z2,'WO Report'!$S:$S,$C$12)+COUNTIFS('WO Report'!$E:$E,Z2,'WO Report'!$S:$S,$D$12)
Thank you for all of your help

Carla