Sum ignoring cells with error
How does one sum up values in a column ignoring cells that contain #N/A error?
|
Sum ignoring cells with error
=SUMIF(A:A,"<#N/A")
for all errors =SUMIF(A:A,"<"&99^99) -- Regards, Peo Sjoblom "JRD" wrote in message ... How does one sum up values in a column ignoring cells that contain #N/A error? |
All times are GMT +1. The time now is 06:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com