Summing to avoid #N/A errors

[saad3000]

Hello, I made an excel sheet with using vlookup to automatically calculates the Price and Retail Price and the Profit based on the items selected in a validation list. However am recieveing an N/A unless i fill the validation list. And i made a Profit cell to sum all the profits in the Cells. But I recieve N/A unless i fill the cells. Is there a way to auto sum the profit when i fill limited cells? I attached the cell sheet below take a look thank you!

[VBA Noob]

Try

=SUMIF(F3:F750,"<>#N/A")

see link to hide errors

http://www.j-walk.com/ss/excel/usertips/tip010.htm

VBA Noob

[saad3000]

THANK YOU!! IT WORKS!!!

There is one more thing, how do I make the Quantity in Sheet 'Recharge-Source'
to decrease automatically if I changed in Quatity of "RECHARGE MARCH 08" Cell Quantity??

[VBA Noob]

Maybe

=15-SUMIF('RECHARGES-MARCH-08'!B:B,'RECHARGE-SOURCE'!A2,'RECHARGES-MARCH-08'!C:C)

Where 15 is your opening stock. 'RECHARGE-SOURCE'!A2 = Cards MTC-22

VBA Noob

[saad3000]

Thank you, but the thing is that i might re-add the stock, and now when i select the 1st item and put 1 in q it decreases also the 2nd item in the RECHARGE-SOURCE ..

Any other way or formula?

[VBA Noob]

Have the formula in a seperate cell then.

VBA Noob