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...
With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. You could get a precise solution much faster with a file (w/out sensitive data). This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.
Thank you for your understanding and patience
NikolinoDE
I know I don't know anything (Socrates)
Thank you for your understanding and patience
NikolinoDE
I know I don't know anything (Socrates)
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.
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.
