Forum Discussion
COUNTIFS value error
I'm getting a value error with the countifs function referencing more than one criteria in another worksheet within the same workbook. The countif function works at the top level (age), but when I wa...
You can use the IFERROR function
See the examble in the file.
Thank you for your understanding
NikolinoDE
I know I don't know anything (Socrates)
Thanks for this! Unfortunately, it did not work :(. The formula isn't populating for the second level (MDD vs. CTL) or further. The diagram is to show how many people we have at each level so for every person who is 35-44 AND their group is CTL then they would be counted in that cell.
For COUNTIFS() you shall use range of the same size. Currently
=COUNTIFS( 'Participant Tracking'!E31:E281, 'Participant Tracking'!A543, 'Participant Tracking'!D31:D531,'Participant Tracking'!A555 )If you change second range on 'Participant Tracking'!D31:D281 it shall return some value, not an error.
