Thread
:
running sum
View Single Post
#
2
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
running sum
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
Replace @mailinator.com with @tiscali.co.uk
"Pammy" wrote in message
...
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,
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann