running sum

[Guest]

I have a column (f) that has a vlookup formula that looks up the employee and
brings back their overtime rate, column e shows the overtime hrs worked if
any.
column g gives a total amt by multiplying f*e. In column J2 I want a total
monthy cost the sum of G3:g500. The problem, it shows a #NA in the J2
column. In column F if I do not have any inform from the vlookup, it gives a
#NA, so In column J it also gives a #NA. Even though I have numbers in
g3:g200, I am not showing the total sum in J2, it is showing a #NA. What can
I do to get rid of the #NA error?

Thanks,

 

[Sandy Mann]

In Column F change the VLOOKUP() formulas to:

=IF(ISNA(F3),"",Your VLOOKUP() formula)

and copy down.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk