| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum, except #N/A
Hi, i have this code : =SUMPRODUCT(--SUBSTITUTE(C4:AA4,"Late ",""))
In some cells i have #N/A , and the code it's not working anymore. I need the code to sum everything but to ignore #N/A. Can this be done? Thanks! |
Threaded Mode
