ExcelBanter - formula to count cells containing #'s in a specific range

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula to count cells containing #'s in a specific range (https://www.excelbanter.com/excel-worksheet-functions/85749-formula-count-cells-containing-s-specific-range.html)

woogiebooboo

formula to count cells containing #'s in a specific range

I know this is going to be an easy answer nut I just cant figure it out...
How do I count a cell that is greater than a specific and less than a
another specific number....or to count it if it contains a number in a
specific range?

Gary''s Student

formula to count cells containing #'s in a specific range

Use COUNTIF():

=COUNTIF(A1:A10,"3")-COUNTIF(A1:A10,"7")

will count the number of cells with value greater than 3 and less than 7

--
Gary's Student

"woogiebooboo" wrote:

I know this is going to be an easy answer nut I just cant figure it out...
How do I count a cell that is greater than a specific and less than a
another specific number....or to count it if it contains a number in a
specific range?

All times are GMT +1. The time now is 10:36 AM.