M Mike Oct 9, 2003 #1 When asking cell A1 to give you the sum of A2:A10 is it possible to ignore the cells in the range that contain (#n/a.
When asking cell A1 to give you the sum of A2:A10 is it possible to ignore the cells in the range that contain (#n/a.
D Daniel Klann Oct 9, 2003 #2 Hi Mike, Try using SUMIF e.g. =SUMIF(A2:A10,"<>#N/A",A2:A10) Hope this helps, Daniel Klann http://www.danielklann.com - goto the Excel section for a few useful tricks....
Hi Mike, Try using SUMIF e.g. =SUMIF(A2:A10,"<>#N/A",A2:A10) Hope this helps, Daniel Klann http://www.danielklann.com - goto the Excel section for a few useful tricks....
M mike Oct 9, 2003 #3 A 1,000 Thank yous Daniel, I'll give it a try. -----Original Message----- Hi Mike, Try using SUMIF e.g. =SUMIF(A2:A10,"<>#N/A",A2:A10) Hope this helps, Daniel Klann http://www.danielklann.com - goto the Excel section for a few useful tricks.... . Click to expand...
A 1,000 Thank yous Daniel, I'll give it a try. -----Original Message----- Hi Mike, Try using SUMIF e.g. =SUMIF(A2:A10,"<>#N/A",A2:A10) Hope this helps, Daniel Klann http://www.danielklann.com - goto the Excel section for a few useful tricks.... . Click to expand...
