HELP!!! Cant seem to get the totals to work

[dshamp]

Im going to preface this by saying I am a excel newbie.
I am trying to get this speadsheet to have some of the cells remain blank until others are filled in. Which apparently I have to many convoluted formulas to make the simple total at the end work. I am open to fixing anything that doesnt make sense. Any help would be very much appreciated.

Print Pricing 4:20.xlsx

[dshamp]

I am curious if I am using the IF statements correctly.

[sktneer]

You are using ISBLANK() to check whether col. E has not value and it will return False as col. E is not blank actually but it contains formula in it.
So try this.......
In F3

Please Login or Register  to view this content.

and copy down.

Make similar formulas for other columns as well.

[bebo021999]

Maybe in F3:

=IFERROR(B3*E3+2,"")

[sktneer]

Similarly in H3, try this......

Please Login or Register  to view this content.

and copy down.

[dshamp]

Thank you all....those suggestions really solved my issue.

[sktneer]

You're welcome. Glad we could help.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.