help running/cumulative total

[rjc_29]

Is there a way i can have a formula that adds up the number of cells with information in which is text and numerical.

currently the running total has to be manually calculated (example of screen grab attached) by having the columns headings numbered.

[sweep]

Hi,

How about the =COUNTA(range) function?

[rjc_29]

thanks it works