# Is there an easier way to write this formula?

#### jjackson

##### New Member
=IF(G20>=1,G20+G19+G18+G17+F21+F20+F19+F18+F17,0)

I have been having problems when I put it this way it wont add the two columns.
=IF(G20>1,G20:G17,F17:F21,0)

Jaye

### Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the \$ sign).

#### Smitty

##### Legend
How's this:

=IF(G20>1,SUM(G17:G20)+SUM(F17:F21),0)

Hope that helps,

Smitty

#### jjackson

##### New Member
That helped out so much thanks...
The only problem is that I dont want empty cells to show up as a number I want them to show up as a Zero or nothing.

Ok I figured it out, I had the wrong numbers in the wrong cells... Sorry...
That helped a bunch....

#### BJungheim

##### Well-known Member
Why not:

=IF(G20>1,SUM(G17:G20,F17:F21),0)

?

#### Smitty

##### Legend
Why not:

=IF(G20>1,SUM(G17:G20,F17:F21),0)

Good point - Brain Fart.

Smitty

#### jjackson

##### New Member
Thank you so much for your help... Saved me alot of time with the other formulas...

Replies
5
Views
156
Replies
7
Views
62
Replies
7
Views
126
Replies
3
Views
353
Replies
3
Views
142