| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
suming blank cells
I am trying to add 2 cells together. Sometimes 1 of the 2 cell sthat I am
trying to add together is blank. When one of the cells is blank it is not returning an answer for me, any way around this? thanks, JAse |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
suming blank cells
Sounds like there may be, say, " " in the cell. So, if (cell1="
",cell2,if(cell2="",cell1,cell1+cell2)) "Jase" wrote: I am trying to add 2 cells together. Sometimes 1 of the 2 cell sthat I am trying to add together is blank. When one of the cells is blank it is not returning an answer for me, any way around this? thanks, JAse |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
suming blank cells
Use SUM, it will ignore text
Eg in C1: =SUM(A1:B1) [instead of in C1: =A1+B1] -- Max Singapore http://savefile.com/projects/236895 Downloads:18,300 Files:361 Subscribers:58 xdemechanik --- "Jase" wrote: I am trying to add 2 cells together. Sometimes 1 of the 2 cell sthat I am trying to add together is blank. When one of the cells is blank it is not returning an answer for me, any way around this? thanks, JAse |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
suming blank cells
That works, thanks,
"Max" wrote: Use SUM, it will ignore text Eg in C1: =SUM(A1:B1) [instead of in C1: =A1+B1] -- Max Singapore http://savefile.com/projects/236895 Downloads:18,300 Files:361 Subscribers:58 xdemechanik --- "Jase" wrote: I am trying to add 2 cells together. Sometimes 1 of the 2 cell sthat I am trying to add together is blank. When one of the cells is blank it is not returning an answer for me, any way around this? thanks, JAse |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
suming blank cells
Actually, what if my columns are not right next to each other?
thanks, Jase "Max" wrote: Use SUM, it will ignore text Eg in C1: =SUM(A1:B1) [instead of in C1: =A1+B1] -- Max Singapore http://savefile.com/projects/236895 Downloads:18,300 Files:361 Subscribers:58 xdemechanik --- "Jase" wrote: I am trying to add 2 cells together. Sometimes 1 of the 2 cell sthat I am trying to add together is blank. When one of the cells is blank it is not returning an answer for me, any way around this? thanks, JAse |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
suming blank cells
=SUM(A2,C2)
"Jase" wrote: Actually, what if my columns are not right next to each other? thanks, Jase "Max" wrote: Use SUM, it will ignore text Eg in C1: =SUM(A1:B1) [instead of in C1: =A1+B1] -- Max Singapore http://savefile.com/projects/236895 Downloads:18,300 Files:361 Subscribers:58 xdemechanik --- "Jase" wrote: I am trying to add 2 cells together. Sometimes 1 of the 2 cell sthat I am trying to add together is blank. When one of the cells is blank it is not returning an answer for me, any way around this? thanks, JAse |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
suming blank cells
Actually, what if my columns are not right next to each other?
Then like this, in say, E1: =SUM(A1,C1) Pl press the "Yes" button below in all responses which help -- Max Singapore http://savefile.com/projects/236895 Downloads:18,300 Files:361 Subscribers:58 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Suming Cells that contain text data | Excel Worksheet Functions | |||
| Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
| suming in add-ins | Excel Worksheet Functions | |||
| Suming selected cells based on two criteria | Excel Worksheet Functions | |||
| Suming 2 cells if 1 = #N/A | Excel Worksheet Functions | |||
Linear Mode
