suming blank cells

[Jase]

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

 

[Sean Timmons]

Sounds like there may be, say, " " in the cell. So, if (cell1="
",cell2,if(cell2="",cell1,cell1+cell2))

 

[Max]

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]

That works, thanks,

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
---

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

 

[Jase]

Actually, what if my columns are not right next to each other?

thanks,

Jase

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
---

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

 

[Sean Timmons]

=SUM(A2,C2)

Actually, what if my columns are not right next to each other?

thanks,

Jase

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
---

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

 

[Max]

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
---