Is there an easier way to write this formula?

jjackson

New Member
Joined
Nov 21, 2005
Messages
28
=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)

Thanks for your help...
Jaye
 

Some videos you may like

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
Joined
May 15, 2003
Messages
29,536
How's this:

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

Hope that helps,

Smitty
 

jjackson

New Member
Joined
Nov 21, 2005
Messages
28
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....
 

jjackson

New Member
Joined
Nov 21, 2005
Messages
28
Thank you so much for your help... Saved me alot of time with the other formulas...
 

Watch MrExcel Video

Forum statistics

Threads
1,118,056
Messages
5,569,953
Members
412,299
Latest member
agentless
Top