Time sheet tracker: sum instance of text formula issue

**smls** · 08-28-2012, 02:21 PM

time tracker.xlsx

I attached a file to help with this. I know its a simple problem but my brain can't seem to solve it right now. I want my fomula in row 47 to count each instance of text appearing in the rows above it and add .25 to a running total for each non blank row.

Thanks in advance for your help

**JieJenn** · 08-28-2012, 02:27 PM

=counta(c6:c46)+counta(c6:c46)*0.25 ?

**K m** · 08-28-2012, 02:29 PM

=counta(c6:c46)*0.25

**smls** · 08-28-2012, 02:31 PM

Please Login or Register  to view this content.

worked well, didn't need the blank part.

Thanks, my brain blanked on hte best way to just count cells that had text in them. Is there anyway to only count text though and not anything going into the cell?

**K m** · 08-28-2012, 02:41 PM

Yes,

COUNT counts cells containing numeric values
COUNTA counts cells are not empty

COUNTA - COUNT (you need to supply the range) will count cells containing text