I have a table for each person that's periodically updated with essentially 3
columns: A = week ending dates, B= work hours, and C= travel hours. For any
given week, there may be hours logged under columns B and C, OR B or C, OR
neither. I need to calculate the average weekly hours for each person. I
think I need some sort of formula that combines COUNTIF and Blanks but I
can't seem to figure it out. I don't want to count a week twice when they
log both types of hours, and since they could log either type of hours and
not always one or the other, I think this is my problem spot. Hope someone
can help.
--
Thanks