| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif if cell does not equal #N/A
I would like to sum a column with some #N/A in it.
I tried using sumif with < "#N/A" with no luck. What is the criteria for not equal in this function? Do I have to treat "#N/A" in a special way? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumif if cell does not equal #N/A
=SUMIF(J:J,"<#N/A",J:J)
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Micah" wrote in message ... I would like to sum a column with some #N/A in it. I tried using sumif with < "#N/A" with no luck. What is the criteria for not equal in this function? Do I have to treat "#N/A" in a special way? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Can i tell the cell to equal the pattern in another cell? | Excel Discussion (Misc queries) | |||
| How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
| make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Linear Mode
