Oct 19 2021 07:58 AM
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 want to add age and group (e.g., CTL or MDD) as a second criteria the countifs function does not work. Attached a screenshot.
Oct 19 2021 11:26 AM
Oct 19 2021 11:36 AM
@NikolinoDE I attached it here. For reference, the formulas in the participant tracking sheet tables pull from labels in cells A543-566. I'd like the demographics diagram sheet to pull from the participant tracking sheet. Again, the top level (age) pulls successfully, but not when I add age AND another demographic and so on and so forth.
Oct 20 2021 11:11 AM
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)
Oct 21 2021 10:43 AM
Oct 23 2021 03:51 AM
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.