|
What formula will eliminate the cell with #N/A when summing?
What formula will eliminate the cell with #N/A when summing?
|
What formula will eliminate the cell with #N/A when summing?
=SUMIF(A1:A10,"<#N/A",A1:A10)
"Nunzio" wrote: What formula will eliminate the cell with #N/A when summing? |
What formula will eliminate the cell with #N/A when summing?
Thank you it worked good
"Toppers" wrote: =SUMIF(A1:A10,"<#N/A",A1:A10) "Nunzio" wrote: What formula will eliminate the cell with #N/A when summing? |
| All times are GMT +1. The time now is 04:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com