One more question. Every time I try to use the count function it keeps
displaying 0 even though I have values. For example:

H
1 REC 21
2 REC 24
3 REC 19
4 REC 22
5 REC 21

Which I would then use the formula =COUNT(H1:H5) which should display 5, but
it shows 0.

Does anyone know why this could be happening?

[ExcelBanter AI]

Troubleshooting the COUNT Function in Excel

1. Make sure that the cells you're counting actually contain values, and not just formulas or empty cells.
2. Check that the cells you're counting are formatted as numbers, and not as text.
3. If the cells you're counting contain numbers with decimal places, make sure that the decimal separator in your Excel settings matches the separator used in the cells.
4. If none of the above solutions work, try using the SUM function instead of the COUNT function to see if the cells are being recognized as numbers.

The COUNT(...) function only counts numeric values. To count all values use
COUNTA(...), so your formula would be:

=COUNTA(H1:H5)
--
Regards,

Dave


"dnm" wrote:

One more question. Every time I try to use the count function it keeps
displaying 0 even though I have values. For example:

H
1 REC 21
2 REC 24
3 REC 19
4 REC 22
5 REC 21

Which I would then use the formula =COUNT(H1:H5) which should display 5, but
it shows 0.

Does anyone know why this could be happening?

Awesome! Thanks

"DaveB" wrote:

The COUNT(...) function only counts numeric values. To count all values use
COUNTA(...), so your formula would be:

=COUNTA(H1:H5)
--
Regards,

Dave


"dnm" wrote:

One more question. Every time I try to use the count function it keeps
displaying 0 even though I have values. For example:

H
1 REC 21
2 REC 24
3 REC 19
4 REC 22
5 REC 21

Which I would then use the formula =COUNT(H1:H5) which should display 5, but
it shows 0.

Does anyone know why this could be happening?

[kimmie]

So with this formula and example the answer is 5; however, is there a way to
use a formula to count similiar data. For instance,

Rec 21 will have a count of 2 in the next column because it appears 2.
Rec 24 will have a count of 1 in the next column because it only appears once.

Thanks for your assistance!



"dnm" wrote:

One more question. Every time I try to use the count function it keeps
displaying 0 even though I have values. For example:

H
1 REC 21
2 REC 24
3 REC 19
4 REC 22
5 REC 21

Which I would then use the formula =COUNT(H1:H5) which should display 5, but
it shows 0.

Does anyone know why this could be happening?

[smartin]

Kimmie wrote:
So with this formula and example the answer is 5; however, is there a way to
use a formula to count similiar data. For instance,

Rec 21 will have a count of 2 in the next column because it appears 2.
Rec 24 will have a count of 1 in the next column because it only appears once.

Thanks for your assistance!

Try
=COUNTIF($H$1:$H$5,H1)