mbesspiata
Board Regular
- Joined
- Aug 28, 2009
- Messages
- 100
I have a spreadsheet that workers can use a drop down in column a and by way of a vlookup function in columns b and c, it will place the unit of measure and cost per unit associated with the item entered in column A.
The problem I have is that I have copied my formulas down through 10 rows to allow for additional entries and if there is no entry, colums b and c give me the #N/A. The problem is that I have a total at the bottom which doesn't work with the #N/A in the b and c columns.
How can I get the total at the bottom to add the figures entered above while ignoring the #N/A?
<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>
thanks
Mike
The problem I have is that I have copied my formulas down through 10 rows to allow for additional entries and if there is no entry, colums b and c give me the #N/A. The problem is that I have a total at the bottom which doesn't work with the #N/A in the b and c columns.
How can I get the total at the bottom to add the figures entered above while ignoring the #N/A?
9AA - Destruction of Routine, Non-Hazardous</SPAN> | per ton </SPAN> | $175.00</SPAN> |
#N/A</SPAN> | #N/A</SPAN> | |
#N/A</SPAN> | #N/A</SPAN> | |
#N/A</SPAN> | #N/A</SPAN> | |
#N/A</SPAN> | #N/A</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>
thanks
Mike