Disreguard #N/A when adding a column of numbers.

rjagain62

New Member
Joined
Jan 11, 2011
Messages
6
I have a column of numbers that come from a vlookup.
I want to add this column up skipping the cells with a #N/A result from the vlookup.

Thanks guys.
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,087
Office Version
365
Platform
Windows
How about
=AGGREGATE(9,6,E2:E7)
Change range in red to suit
 

Watch MrExcel Video

Forum statistics

Threads
1,099,788
Messages
5,470,786
Members
406,721
Latest member
Laiceyshae

This Week's Hot Topics

Top