=countif function

  • Thread starter Thread starter LindsayPTMFUS
  • Start date Start date
L

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
 
=COUNTA(A6:A47)

should do it.

--

Vasant

LindsayPTMFUS said:
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


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top