Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#n/a drving me mad, need to force ignore or remove them - Help!
Hi,
Please help, I have tried hard to rectify this using some different formula etc but to no avail. I have a spreadsheet which logs visits to customers so that we can get a % of visits which become orders, however we need this by Team/Individual/Product etc, so gets more intense. I have broken it down as far as possible to collate the data. I am using formula: =IF((AND(F4="Education",H40)),H4,0) to get the value of orders/team. i.e. if F4 is the Education Team and a figure is in order column over zero then put the figure (as this is an order). The Team column (i.e. Education) comes from a VLOOKUP table, so therefore they select staff initials (from drop down list) and it automatically looks up the team name. This works great until the blank lines, no initials selected, results in no team name (#n/a) and #N/A's in my result - This wouldn't matter only I cannot add up a column with them appearing, result in AutoSum is (yes you guessed it!) #N/A!! Am I missing something glaringly obvious? Please help, I'm so close to finishing this one! I have tried =if(ISNA..... but cannot seem to get it to work,. not sure if I am using this in the correct place. -- Ang. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove convert/extract the number from'12345.56; ie remove ' sign | Excel Worksheet Functions | |||
How do I remove hyperlink if 'remove' option is disabled | New Users to Excel | |||
how to force a lookup | Excel Worksheet Functions | |||
force a $0.00 | Excel Discussion (Misc queries) | |||
Force Tab | Excel Worksheet Functions |