sumif problem

  • Thread starter Thread starter freekrill
  • Start date Start date
F

freekrill

I have a column of data, some cells of which include error value
(#value and #N/A). If I attempt to SUM, I get an error. Can I use SUMI
so that it will exclude error values and just add the numbers?

Thanks

fre
 
Hi freekrill!

Here's an array formula approach:

=SUM(IF(ISERROR($A$1:$A$100),0,$A$1:$A$100))
Entered as an array by pressing and holding down Ctrl + Shift and then
pressing Enter.

Appears in the cell as:

{=SUM(IF(ISERROR($A$1:$A$100),0,$A$1:$A$100))}

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top