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