Forum Discussion
Conditional XLookups and Counts
I have a spreadsheet with two sheets to count up survey responses. One has all the possible results i.e each survey group (1,2,3,4) where they're based, the question and then possible result. I've tr...
If I understand your objective, you'll want to use COUNTIFS instead of XLOOKUP.
=COUNTIFS($O$2:$O$7,C2,$P$2:$P$7,E2,$Q$2:$Q$7,F2)