Counting cells

[thekgbjr]

I am creating an invoice for Home Health Agency. There will be a summary page and on that I need to be able to refer to the invoice page and count the number of times a nurse has visited a home. In other words the invoice will be listed by date so I need to have a formula that will count the number of lines on the invoice and put that number on the sumamry page....thoughts?

 

[Jared_8878]

if the invoice is a set range
then set up a count on that range

for instance:
if D4:D15 have the possibility of having dates, then setup the count like this:
=COUNT(D4:D15)

since you said on the other sheet, I assume you know but just in case:
on the result sheet you just reference the source sheet such as
=COUNT(Sheet1!D4:D15)
where 'Sheet1!' is your invoice sheet's name.

 

[thekgbjr]

but if the cell is blank how do I keep it from counting blank cells?

 

[scottylad2]

I am creating an invoice for Home Health Agency. There will be a summary page and on that I need to be able to refer to the invoice page and count the number of times a nurse has visited a home. In other words the invoice will be listed by date so I need to have a formula that will count the number of lines on the invoice and put that number on the sumamry page....thoughts?

will your tabs be called after a date? or will you have entries on a tab named for instance visits, and you want to count between certain dates on the visits tab?

 

[stilesbn]

but if the cell is blank how do I keep it from counting blank cells?

count functions will not count blank cells

=COUNT() will count ranges with only numbers in it.
=COUNTA() will count cells that are not blank (Whether they have text or numbers)