I am trying to count the number of times I've bowled 100-109, 110-119, etc. I know the formula to count for one column when I've bowled below 100, which is
=COUNTIF(D3
40,"<100")
but I have no idea how to limit the count to between 100 and 109, and so on.
Also, I'd like to count for all the columns on the page. I realize I can just do =SUM(A1+B2+C2) for all of the COUNTIF formulas I made, but I would prefer to just enter 1 formula for the whole page.
Thanks in advance to anyone who can help
=COUNTIF(D3
40,"<100")but I have no idea how to limit the count to between 100 and 109, and so on.
Also, I'd like to count for all the columns on the page. I realize I can just do =SUM(A1+B2+C2) for all of the COUNTIF formulas I made, but I would prefer to just enter 1 formula for the whole page.
Thanks in advance to anyone who can help