Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Ask your geeky hard core Excel questions here!
How do I make the "criteria range" in a COUNTIF function dynamic?
I need a way to reference a key cell in the criteria range of COUNTIF. I will change this cell for each report depending on where in the hierarchy the individual is. I need the COUNTIF function to switch columns based on the value in this key cell.
Or is there simply a better way to go about counting these instances?
Note: If it matters, I'm using countifs, but only one part of the formula needs to adapt as described above. Read More