I have forgot how in Excel to get the numbers in one cell to fill in if another cell has something in it?

Question

Example. B1 has 12 C 1 has 56789
In need to get B2 to say 13 if there is any info in C2

what i have is a spread sheet that holds data and i need to ge B1 to count down if there is any info in C1 etc. i may not be asking it the right way.

Example
cell
B1 has 12 in it C1 has 5436
B2 has 13 in it C2 has 3345
how do i change B1 to say 14 then for for B2 to say 15 if there is info in C1 the info may change i just need to change the numbers in column B every week

Answer 1

If you want B1 to count the number for cells in column C that have values, use this:
=COUNTA(C:C)
but remember that it will count every cell in the range that has anything in it, including text. If you only want numbers counted, you might use something like this:
=COUNTA(C:C) - COUNTIF(C:C,">''")

Note that the last part is:
"> ' ' " )
but without the spaces!

Answer 2

In B2, enter the following formula:
=if(C2=0, 0, B1+1)

Answer 3

in B2 enter IF(C2=0,13,else) don't type "else"
This means that if C2=0, C1=13 if it doesn't, it equals whatever value you type after the comma.

What are you trying to do? This seems a little backwards to me -- to enter data in C then have something entered in B.