Forum Discussion
Solved
Helps with Countifs function
I need help with figuring out how to write a formula. I have a spreadsheet with two columns containing data that I need to evaluate. The first column contains two dozen different department names. ...
Hi Vincent,
With two OR conditions you shall use columns conditional array in one case and rows array in another one, like
=SUM(COUNTIFS(Data!$A:$A,{"Commuter Operations","Facilities","FinOps","OPM/CHSA/COBRA","Vendor Management"},Data!$B:$B,{"Strongly Agree";"Agree"}))More about that is here https://exceljet.net/formula/countifs-with-multiple-criteria-and-or-logic
Attcahed
Thank you for your response. I've uploaded an example. On the second tab I've provided details of what I'm trying to do. Please let me know if you have any other questions.
Hi Vincent,
With two OR conditions you shall use columns conditional array in one case and rows array in another one, like
=SUM(COUNTIFS(Data!$A:$A,{"Commuter Operations","Facilities","FinOps","OPM/CHSA/COBRA","Vendor Management"},Data!$B:$B,{"Strongly Agree";"Agree"}))
More about that is here https://exceljet.net/formula/countifs-with-multiple-criteria-and-or-logic
Attcahed
Thank you! This solved my problem. I really appreciate your help.