Thread: Sum in rows or columns that have #N/A in some cells!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Sum in rows or columns that have #N/A in some cells!
Fwiw, this also seems to work over a rectangular range, ignoring #N/As:
=SUMIF(A1:F6,"<#N/A")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"tywlam" wrote:
It works although I have to change the formula a lot!

Reply With QuoteReply With Quote