About Us

Len

Hi,

Thanks for all of your reply

It works.

Regards
Len

Tushar Mehta wrote:
The usual approach would be the array formula
=SUM(IF(ISERROR(A1:A7),,A1:A7))

But, in your case, you also have those large numbers in rows 2 and 5
that you apparently want to ignore. If they are text then the above
formula will work.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article .com,
says...
Hi,

How to use ISERROR or SUM+IF+ISERROR function to ignore cell error
while adding up the value in the selected cells ?
e.g
A B C D
1 100.00 #N/A #N/A 845.00
2 38412100 31789400 34214600 34214600
3 100.00 #N/A #N/A #N/A
4 #N/A C 34182.770 34182.770
5 36479.1450 #N/A #N/A #N/A
6 #N/A 245.00 50.00 140.00
7 #N/A 174.00 #N/A #N/A

200.00 174.00 - 985.00
Note (a) (b) (c) (d)

Note
(a) excel formula to add up the selected cells ( ie A1+A3+A7) and
the
result is 200.00
(b)excel formula to add up the selected cells ( ie A1+A3+A7) and
the
result is 174.00
(c)excel formula to add up the selected cells ( ie A1+A3+A7) and
the
result is 0.00
(d)excel formula to add up the selected cells ( ie A1+A3+A6+A7)
and
the result is 985.00

Please help me to solve the above problem
Thanks

Regards
Len

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ISERROR function	Gotroots	Excel Worksheet Functions	2	January 6th 10 01:21 PM
how do I write a vlookup function within an iserror function so t.	JBLeeds	Excel Worksheet Functions	2	March 16th 05 10:30 AM
IsError Function	Markus Scheible[_2_]	Excel Programming	8	January 26th 05 03:46 PM
Can I use ISERROR with VLOOKUP function?	Prabha	Excel Programming	0	September 21st 04 05:05 PM
Can I use ISERROR with VLOOKUP function?	Frank Kabel	Excel Programming	0	September 20th 04 04:36 PM

Menu

About Us