| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding text to the result of a formula? | Excel Worksheet Functions | |||
| Adding a prefix to a cell by using a formula | Excel Discussion (Misc queries) | |||
| Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
| Adding a formula to a pivot table | Excel Discussion (Misc queries) | |||
| Adding TR to the end of each value in a column..formula | Excel Worksheet Functions | |||
Linear Mode
