Formula help : adding
 

I a new to excel and as a learning project I am makig a list of my movies. I
would like a formula that would add up the cells with text in them. There
are some blank cells as seperation for alphabetizing and I don't want to add
those cells in my total. There aren't any numbers in the cells and I am
struggling to make up a formula. Any help would be appreciated. Thank you

Niki

look at COUNTA

Regards

Trevor


"Niki" <Niki @discussions.microsoft.com wrote in message
...
I a new to excel and as a learning project I am makig a list of my movies.
I
would like a formula that would add up the cells with text in them. There
are some blank cells as seperation for alphabetizing and I don't want to
add
those cells in my total. There aren't any numbers in the cells and I am
struggling to make up a formula. Any help would be appreciated. Thank you

Trevor

Thank You so much !! It WORKS !!

"Trevor Shuttleworth" wrote:

Niki

look at COUNTA

Regards

Trevor


"Niki" <Niki @discussions.microsoft.com wrote in message
...
I a new to excel and as a learning project I am makig a list of my movies.
I
would like a formula that would add up the cells with text in them. There
are some blank cells as seperation for alphabetizing and I don't want to
add
those cells in my total. There aren't any numbers in the cells and I am
struggling to make up a formula. Any help would be appreciated. Thank you

You're welcome. Thanks for the feedback.


"Niki" wrote in message
...
Trevor

Thank You so much !! It WORKS !!

"Trevor Shuttleworth" wrote:

Niki

look at COUNTA

Regards

Trevor


"Niki" <Niki @discussions.microsoft.com wrote in message
...
I a new to excel and as a learning project I am makig a list of my
movies.
I
would like a formula that would add up the cells with text in them.
There
are some blank cells as seperation for alphabetizing and I don't want
to
add
those cells in my total. There aren't any numbers in the cells and I
am
struggling to make up a formula. Any help would be appreciated. Thank
you