add cells with data

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

Hello all.
I'm trying to find the formula to count how many cells have data.
i.e. I have a Colum which will have data in some of the cells but not all.
The value of the data equals 1, but I have to put a description rather than
the number.
Does any one know?
Thank you
Jen
 
Have you looked in Help to see how COUNT and COUNTA work?
Tell us what some sample data might look like
 
Assuming your Descriptions are in column A, put this in B1

=COUNTA(A:A)&" Descriptions"

It will count 1 for every cell in column A that contains a description.

Vaya con Dios,
Chuck, CABGx3
 
Thanks for that. It worked a treat. I did look in Help but was typing Counta
and not COUNTA.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Count only cells ending with decimal value of .98 4
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Column of formulas with some cells containing data derived from thereformula's I would like to find 2
Insert Cell with IF Formula 0
Retrieving data from a cell in the last row containing data in the worksheet 1
Moving a bunch of data 1

Back
Top