=countif function

[LindsayPTMFUS]

I have a spreadsheet where I have my tips earned each night from my job.
I have running totals or running averages at the end of every column
except for one... the column where I put the date of the shift. Is
there anyway I can put a "countif" function at the end of that cell
that would simply count the entries I have thus far, in other words,
count how many shifts I have on the spreadsheet?

I was thinking something along the lines of:

=COUNTIF(A6:A47,"*") in other words, count that cell if any text at all
appears in it, but Excel obviously didn't like that.

Does anyone have any ideas or know of a different way to attack this?
I know it isn't overly useful, but my totals/averages row looks naked
with that cell not having anything in it.

See:

[image: http://lindsay.ptmfus.com/images/tipsheet2.jpg]

Thanks in advance!!
--Lindsay

 

[Vasant Nanavati]

=COUNTA(A6:A47)

should do it.

--

Vasant

I have a spreadsheet where I have my tips earned each night from my job.
I have running totals or running averages at the end of every column
except for one... the column where I put the date of the shift. Is
there anyway I can put a "countif" function at the end of that cell
that would simply count the entries I have thus far, in other words,
count how many shifts I have on the spreadsheet?

I was thinking something along the lines of:

=COUNTIF(A6:A47,"*") in other words, count that cell if any text at all
appears in it, but Excel obviously didn't like that.

Does anyone have any ideas or know of a different way to attack this?
I know it isn't overly useful, but my totals/averages row looks naked
with that cell not having anything in it.

See:

[image: http://lindsay.ptmfus.com/images/tipsheet2.jpg]

Thanks in advance!!
--Lindsay

creating financial statements