summing values only in excel

B

Bob

I have a spreadsheet that I use to keep track of employees
holiday entitlement. The last column calculates each
employees remaining holiday. If I try to sum all the
remaining holiday for all employees I get a very large
number (31880 days), which is not correct. I think this is
because excel is summing all the formulas in each row. Is
there any way I can sum just the resultant "values" of the
formulas in the "remainder" rows ?

Thanks
Bob
 
B

Bob Phillips

Bob,

Excel won't sum formulas or text, but it will sum results of formulas.

That number looks like a date to me, namely 13/04/1987, that is UK date
style.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top