Thanks so much for your help. I was on to the SUMIF, but am still confused
as to why this works. The contents of the cells that have #N/A is really a
formula (the vlookup), so do you get why in the sumif Excel sees the #N/A and
can use it?

Also, I am not sure what you mean by I'd be better off fixing the #N/A
errors. These really aren't errors. The #N/A is returned because that
employee number does not appear for that week (that person wasn't absent that
week).
Thanks again.
--
Thanks, Allison


"Biff" wrote:

You'd be better off fixing the #N/A errors:

=SUMIF(E2:G2,"<#N/A")

Biff

"Allison" wrote in message
...
I have a workbook with a sheet for each week of the year showing # of days
absent that week for only employees that were absent that week. I have
created a master sheet with all employee names and am doing a vlookup by
emp#
for each week on the master sheet. All of that is OK. But I am now
trying
to do a simple sum on the total absent for the year and sum does not work
with the #N/A error. Can you help?

FIRST LAST EMP# DIVISION Week 1 Week 2 Week 3
Sara Kling GW29 Germany 1 1 1
Sean Willis GBW09 Great Britain #N/A 1 #N/A
Colleen Abel CW58 Canada 2 #N/A #N/A
Teri Binga AW55 Australia #N/A 2 #N/A
Frank Culbert GBC07 Great Britain 3 #N/A #N/A
Kristen DeVinney GBS45 Great Britain #N/A 3 #N/A
Theresa Califano CW19 Canada 0 #N/A #N/A
Barry Bally GC04 Germany #N/A 4 #N/A
Cheryl Halal CA26 Canada 1 #N/A #N/A

--
Thanks, Allison