If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sum of cells containing text
I have a selection of cells and i need the sum if they contain text anyone no
if this is possible? |
#2
|
|||
|
|||
sum of cells containing text
EXCEL 2007
=+COUNTA(M1:M20) - the above will count non blank cells for the specified range. If my comments have helped please hit Yes. Thanks. "charlotte" wrote: I have a selection of cells and i need the sum if they contain text anyone no if this is possible? |
#3
|
|||
|
|||
sum of cells containing text
"charlotte" wrote:
I have a selection of cells and i need the sum if they contain text Do you mean count, not sum? Do you mean count all cells even if they contain text; or do you mean count the cells that contain text, excluding those that are numeric? To count all non-empty cells: =counta(A1:A100) To count cells that contain text, exlcuding those that are numeric: =sumproduct(--istext(A1:A100)) To sum cells, regardless of whether they are numeric or they contain numeric strings as text: =sumproduct(--A1:A100) |
#4
|
|||
|
|||
sum of cells containing text
SUMIF?
http://www.ozgrid.com/Excel/sum-if.htm -- Regards Dave Hawley www.ozgrid.com "charlotte" wrote in message ... I have a selection of cells and i need the sum if they contain text anyone no if this is possible? |
Thread Tools | |
Display Modes | |
|
|