Forum Discussion

maryk1770's avatar
maryk1770
Copper Contributor
Oct 19, 2021

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 want to add age and group (e.g., CTL or MDD) as a second criteria the countifs function does not work. Attached a screenshot. 

excel
Formulas and Functions

5 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Oct 19, 2021
    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)
    • maryk1770's avatar
      maryk1770
      Copper Contributor
      Oct 19, 2021

      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. 

Resources