Forum Discussion
pfmxli
Oct 07, 2025Copper Contributor
COUNTIF help
Does COUNTIF support references to other sheets in the same workbook? Excel is telling me I haven't specified enough arguments, but I've supplied 2, just like in the examples. What am I doing wrong...
OliverScheurich
Oct 07, 2025Gold Contributor
=COUNTIF(Results!D3:Results!D27,">0")
=COUNTIF(Results!D3:D27,">0")
These formulas have two arguments and return the intended result in my sample file. In your formula is one closing bracket too many.