Thread: Formula Error
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cdjudge cdjudge is offline
external usenet poster
 
Posts: 3
Default Formula Error

Thanks for the quick response, but that isn't it either. Could it be anything
else?
--
cjudge


"John C" wrote:

Are you getting any response?

If no response at all, you might check cell C8 on each tab, and ensure it is
not formatted as text. If you are getting an incorrect value, if you copied
and pasted the formula from your workbook here, look at your sum for Nov-Dec
09, you have a space after the first apostrophe.
--
John C


"cdjudge" wrote:

Help!!

I am trying to sum cells in different worksheets to get a total on my
summary page but it will not add the cells.

This is the formula:
=SUM('Jan-Feb 09'!C8, 'Mar-Apr 09'!C8, 'May-June 09'!C8, 'July-Aug 09'!C8,
'Sept-Oct 09'!C8, ' Nov-Dec 09'!C8)

Why won't it calculate the cells?
--
cjudge