G
Guest
I am attempting to do a COUNTIF on a long series of values. I need to count
among the first 100 values for all of the 1, 2, 3, 4. Then count among the
next 100 (101-200) for 1,2,3,4. (repeat 25 times) I am having to go into each
formula and type in the range of cells. Is there a faster way to do this
without naming each range before I create the formulas? Given that the
pattern repeats, it should be easy. . . I want to spend as little time as
possible scrolling up and down. Thank you!
among the first 100 values for all of the 1, 2, 3, 4. Then count among the
next 100 (101-200) for 1,2,3,4. (repeat 25 times) I am having to go into each
formula and type in the range of cells. Is there a faster way to do this
without naming each range before I create the formulas? Given that the
pattern repeats, it should be easy. . . I want to spend as little time as
possible scrolling up and down. Thank you!