Countifs returning Zero

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!

Hey Teylyn,

Thanks for the reply! I just created a sample and it works... but the original file still won't return the values.

When I change the slicer choice, some of the choices return the right number whereas other filter choices return 0. When I check the raw data, they should all be returning some count for "very". However, the "extremely" count never returns a value and is always showing 0.