Home |
Search |
Today's Posts |
#1
|
|||
|
|||
getting the sum of a column with #N/A values in it
I created a VLookup formula to display the value of an item if it exists. If
the value doesn't exist, it displays an #N/A. 1) Can I modify this formula to display a "0" instead of an #N/A? and 2) How can I total a column which only excludes #N/A? A copy of my formula is below. =VLOOKUP(B156,'2003'!B:T,3,0) Thank you very much. Moy Emrick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pbl calculating US$ values | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions | |||
Lookup values in a column and display them in order with no gaps | Excel Worksheet Functions | |||
Move column values w/o formula | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |