Ignore #N/A to calculate running total

**Rockter** · 05-21-2007, 03:38 PM

Quick Question:

I'm trying to track the profit for all of the sales on the attached form. Because the formula shows #N/A until the fields are filled out, I can't do a running total of the profit because box H10 shows #N/A. Can someone take a look and give me a hand? I bet it's an easy fix. Thanks!

Zack

**VBA Noob** · 05-21-2007, 03:42 PM

Try

=SUMIF(I16:I80,"<>#N/A")

This link will show how to hide the #N/A's

http://www.excelforum.com/showpost.p...79&postcount=2

VBA Noob

**Rockter** · 05-21-2007, 04:47 PM

PERFECT! Thanks!

**Rockter** · 05-22-2007, 11:24 AM

How would I add this:

=IF(ISERROR(OriginalFormula),"",OriginalFormula)

to this:

=(VLOOKUP(C16,$A$6:$C$12,3,FALSE))*D16

**VBA Noob** · 05-22-2007, 11:58 AM

mAYBE

=IF(ISERROR(VLOOKUP(C16,$A$6:$C$12,3,FALSE)*D16),"",VLOOKUP(C16,$A$6:$C$12,3,FALSE)*D16)

VBA Noob

**Rockter** · 05-22-2007, 12:06 PM

hmmm that didn't work. Can you take a look at the form and see if you can figure it out? Thank you very much for your help!

The newest version is attached below.