| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing Cells with #N/A
I am working on an invoice that is using VLOOKUP
I have surpressed viewing the #N/A with conditional formatting. However, I would like to have a sum of the columns that I have used this conditional formatting with. I originally did not use conditional formatting. I was trying to create an "ISBLANK" formula which I could not get to work. I know how to surpress the #N/As in printing only but I am doing this for someone who is quite illiterate and they want to view the invoice "cleanly" Any suggestions would be appreciated. Thanks. Happy New Year. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| Excel 2003 :Summing specific cells of a particular color in a colu | Excel Discussion (Misc queries) | |||
| Summing non contiguous cells | Excel Discussion (Misc queries) | |||
| Summing visable cells only | Excel Discussion (Misc queries) | |||
| Summing only those cells that aren't hidden | Excel Worksheet Functions | |||
Threaded Mode
