Solved: Count help

[Emoncada]

I have 4 column headers.

Column A has numbers 1,2,3,4,5 - 500.
Column B has Serial Numbers
Column C has The Status
Column D has Who has it

I would like to have a Total of Serial Numbers from the list auto populate in cell H2.
So once someone enters the machines info it will update the totals by looking at column A and telling H2 how many are on the list.

[lucas]

so you want to count the items in column a or the index numbers.....how many, correct?

[Emoncada]

I just added the numbers in column A hoping it can help so somehow I can have the script look at Column B and what ever cell in Column B has a Serial Number return that A.

[mdmackillop]

=COUNT(A:A), or, if not numeric =COUNTA(A:A)

[lucas]

=COUNT(A1:A50)

[Bob Phillips]

=INDEX(A:A,MATCH("xyz",B:B,0))

[Emoncada]

I want it to count only if there is something in column B.
Example
........A...........................B...............................
........1.......................TFT54302D2....................
........2.......................TFT5659D21....................
........3............................................................
........4............................................................
etc.

So in This Case H2 would equal 2

Hope that helps.

[lucas]

=COUNT(B:B)

[Emoncada]

xld i think you are on the right track.
How can I just have it determine if B value= "" then give previous row Value A.

[Emoncada]

Lucas but Column B is not a number it would be a serial Number more like Text.

[lucas]

use countA

[lucas]

in H2 put =COUNTA(B:B)

[lucas]

Malcolm pointed that out in post #4.....

[Emoncada]

Yes correct that works now A:A didn't.
Thanks.