I'm using Excel 2007 and in column A I have a list of items that I wish to
have a total count of. I have spaces (empty cells) between some items in
column A to make it easier to group (and to see) but was wondering if
there's a way to count the cells that only contain info.

In case I haven't described this clearly, I don't want an addition of these
items (they're words and not numbers), I just want to know how many cells in
column A contain data.

Thanks, Dave Horne

Hi Dave

=COUNTA(A1:A100)

Regards,
Per

"Dave Horne" skrev i meddelelsen
...
I'm using Excel 2007 and in column A I have a list of items that I wish to
have a total count of. I have spaces (empty cells) between some items in
column A to make it easier to group (and to see) but was wondering if
there's a way to count the cells that only contain info.

In case I haven't described this clearly, I don't want an addition of
these items (they're words and not numbers), I just want to know how many
cells in column A contain data.

Thanks, Dave Horne

Per, thank you! It worked like a charm. Dave Horne


"Per Jessen" wrote in message
...
Hi Dave

=COUNTA(A1:A100)

Regards,
Per

"Dave Horne" skrev i meddelelsen
...
I'm using Excel 2007 and in column A I have a list of items that I wish
to have a total count of. I have spaces (empty cells) between some items
in column A to make it easier to group (and to see) but was wondering if
there's a way to count the cells that only contain info.

In case I haven't described this clearly, I don't want an addition of
these items (they're words and not numbers), I just want to know how many
cells in column A contain data.

Thanks, Dave Horne