Sum with NA

slinkyjib

Board Regular
Joined
Aug 2, 2004
Messages
161
Good Morning,

I'm trying to get a forumla to sum a column. But the contents of the column are variable, and may contain N/A. As such I need to sum all the amounts in the column that contain a value, whilst excluding N/a.

My attempt looked like this, though I really am not that good with isna formula's. ( Hope it doesn't show to badly).

=IF((ISNA('Cost & Customer Number'!H4:H2000)),"",(SUM('Cost & Customer Number'!H4:H2000)))

Any help appreciatted.

:)
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
41,704
Office Version
365
Platform
Windows
slinkyjib

Try
=SUMIF('Cost & Customer Number'!H4:H2000,"<>#N/A",'Cost & Customer Number'!H4:H2000)
 

Forum statistics

Threads
1,077,778
Messages
5,336,248
Members
399,072
Latest member
abublitz

Some videos you may like

This Week's Hot Topics

Top