0

Cell A Row 1 = 100 Cell B row 1= 100000 Cell C Total should be = 100

Cell A Row 2 = 0 Cell B Row 2 = 45000 Cell C Row 2 = 45000

Total of Cell C1 + C2 = 45100

user57094
  • 1

1 Answers1

0

I am sorry but your question is not properly presented. You will get better answers if you put some time to better explain what you want to do. Please consider the following points:

  1. This is group for SuperUser questions, however this is probably an Excel question. From your title, it could be a shell script question, or an SQL question or whatever.
  2. In your title you mention "blank" cells, but then, your example, is using a cell with a "0" value. These are not the same.

Supposing that you are referring to excel, cell C1 should have a formula of:

=IF(AND(ISNUMBER(A1),A1<>0),A1,B1)

and then fill cells in the C column accordingly. Then you can just sum the cells in the C column.

Panos
  • 1