Sign up, and you can customize which countdowns you see. Sign up
Aug 5, 2020
7:00:21pm
cougfanblue CB Nose Hair
Excel Help - are you not able to use cell references in the criteria for a countifs function?
I'm trying to count the number of values within a specific range. When I enter in the actual values of the range in the criteria, it counts just fine (12). But I would prefer just referring to a cell that contains that value so I can just copy down. But when I do that, it just returns zero (see below). Is there not a way to do this?

004036d58298ecaca4da260c0c4818c2.jpeg
This message has been modified
Originally posted on Aug 5, 2020 at 7:00:21pm
Message modified by cougfanblue on Aug 5, 2020 at 7:01:25pm
cougfanblue
Previous username
cougfantan
Bio page
cougfanblue
Joined
May 2, 2007
Last login
May 4, 2024
Total posts
128,879 (38,122 FO)
Messages
Author
Time

Posting on CougarBoard

In order to post, you will need to either sign up or log in.