[Solved] Counting how many cells have text entered?

[derek_in_paisley]

Hi,

I'm hoping this isn't too basic a question but I'm stuck.

I'm using the spreadsheet to record an electronic "job ticket" to use in our printing factory but I cant see how to perform a particular calculation.

Each job would have a different number of colours of print, for instance red, blue and black. If the initial designer enters the print colours in three separate cells, how do I perform a calculation including the number of colours of print? Obviously if I can have the sheet calculate from the number of colours and the number of items to be printed, I can calculate a figure for work loading, but how do I get Calc to count the cells with the text entries e.g. red, blue and black would equal 3. A job with gold and magenta would equal 2.

Can that be done?

Thanks for reading!

Derek %-)

[Zizi64]

The function

Code: Select all

COUNTA(Cellrange)

will count all of non-empty cells (e.g.: It counts cells contains Text OR Numbers).

The function

Code: Select all

COUNT(Cellrange)

will count cells contains numerical values only.

Code: Select all

=COUNTA(Cellrange)-COUNT(Cellrange)

will count cells contains text only.

[derek_in_paisley]

Genius! COUNTA() is exactly what I needed.

Thanks for that!

Derek %-)