Countif Question
In the very first row in some column enter:
=COUNTIF($B$2:$F$350,ROW()) and copy down
--
Gary''s Student - gsnu200906
"b4nature" wrote:
How do I get a formula to automatically update to count the number of times a
changing value exists within the same range of cells?
Example:
If my range needs to always be B2:F350, how can I count within that range
how many times the number 1 appears, then 2, then 3, etc.
I have COUNTIF($B$2:$F$350,"=1") but I don't want to have to change the
number every time. I want to copy down so the 1 automatically changes to 2
then 3...
Thanks!
|