I have a colum of vlookup numeric data and want to add it up, but each cell
may not return a value depending on how many items are needed. I belive I
will need to add a colum in and grab the numeric data that is returned and
then use a formula to do a copy paste value and if no value equal zero. I am
not sure how to do this thoe. here is the vlookup formula i am using.
Can you please help

=IF(ISNA(VLOOKUP(A3,'Inventory Items'!$A$3:$C$888,'Inventory
Items'!$C$1,FALSE)),"",(VLOOKUP(A3,'Inventory Items'!$A$3:$C$888,'Inventory
Items'!$C$1,FALSE)))

Thank you