unused dropdown cells causing #VALUE! error in column totals

Hello everyone! 1st post

I have a drop down pulling information to autofill cells. If all the drop downs are full I don't have the Autosum issue at the total line.

I didnt know if there was an exception I could use instead of deleting the lines that have the #VALUE! error to the totals will auto sum if all the drop downs are not used.

Basically I want the #value! error to go away and not hinder the column totals if possible

Thanks in advance!

Change your formula in G3 to this:

=IF(B3="","",ROUNDUP(D3/$B$1*B3,-1))

and copy down to row 25. Make a similar change to J3:

=IF(B3="","",E3*B3)

Hope this helps.

Pete

Perfect

I must be quite the novice since it was solved so quickly!

Thanks Pete!

Originally Posted by ConneXionLost

I notice, in columns D,E,and F, you are using an IF function to eliminate this same error:

Please Login or Register  to view this content.

Why don't you do the same thing in columns G and J?

I knew IF was the key, just didnt know how to execute it... didnt know this sheet had those attempts