| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ignore text when sum cells
I have two columns with numbers, blanks, and text.
I want to sum these two columns (C1=A1+B1) if there is a number in either column, leave a blank if both columns are blank, and ignore text. When I have text in these columns, I get: #VALUE! How can I ignore text and return a blank instead of zero if there are two blanks? Example: IN ABV 204 #VALUE! IN ABV IN ABV #VALUE! IN ABV IN ABV #VALUE! 15,327 264 15,591 Thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ignore text when sum cells
Hi
Try =IF(COUNT(A1:B1)0,SUM(A1:B1),"") copied down Richard "evoxfan" wrote in message ... I have two columns with numbers, blanks, and text. I want to sum these two columns (C1=A1+B1) if there is a number in either column, leave a blank if both columns are blank, and ignore text. When I have text in these columns, I get: #VALUE! How can I ignore text and return a blank instead of zero if there are two blanks? Example: IN ABV 204 #VALUE! IN ABV IN ABV #VALUE! IN ABV IN ABV #VALUE! 15,327 264 15,591 Thanks in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ignore text when sum cells
Try this:
=IF(COUNT(A1:B1),SUM(A1:B1),"") -- Biff Microsoft Excel MVP "evoxfan" wrote in message ... I have two columns with numbers, blanks, and text. I want to sum these two columns (C1=A1+B1) if there is a number in either column, leave a blank if both columns are blank, and ignore text. When I have text in these columns, I get: #VALUE! How can I ignore text and return a blank instead of zero if there are two blanks? Example: IN ABV 204 #VALUE! IN ABV IN ABV #VALUE! IN ABV IN ABV #VALUE! 15,327 264 15,591 Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cells ignore Wrap Text formatting! | Excel Discussion (Misc queries) | |||
| creating formulas which ignore text in the relevant cells | Excel Discussion (Misc queries) | |||
| check a row ignore blank cells print only those with text | Excel Discussion (Misc queries) | |||
| Ignore Text in Cells Referenced in a formula | Excel Discussion (Misc queries) | |||
| How do I count cells with text but ignore cells with spaces? | Excel Discussion (Misc queries) | |||
Linear Mode
