Hi all,
I'm trying to set up a countifs table.
The countifs are based off the raw data and have the following criteria.
=COUNTIFS('Source data'!$L:$L,'DWP One Choice'!$L$9,'Source data'!$V:$V,$L13,'Source data'!$W:$W,"very")
First criteria is matching against a cell linked to a slicer (the course name) which changes based on the slicer choice.
Second is based on a specific question.
Third I want to return the count of answers "very" and "extremely" from the same column.
But when swapping through the slicer, sometimes it returns the correct number while other times I get a 0 (although there are 'very' and 'extremely's).
Any idea why this may be happening?
Thanks, Mike!
Bookmarks