suming blank cells

J

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
 
S

Sean Timmons

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

Jase

That works, thanks,

Max said:
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 said:
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
Click to expand...
Click to expand...
 
J

Jase

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

thanks,

Jase

Max said:
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 said:
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
Click to expand...
Click to expand...
 
S

Sean Timmons

=SUM(A2,C2)

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

thanks,

Jase

Max said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
M

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Publisher adding blank page when printing my booklet... 2
Newbie Help - IF Yes No Function 0
Word 2007 flash screen upside down and Word2007 cannot be used 0
Return last non-blank cell in column 3
Visio: copy text of a master shape to User-define Cells (Variable) 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Mail Merge Switch - Dollars to Words 0
if there is a blank ,how to get the blank cell in a range be highlighted 2

Top