Formula Error

C

cdjudge

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?
 
J

John C

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.
 
C

cdjudge

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

cdjudge

I fixed the formulas in each worksheet. I had added in the cell that has the
sum which is C8 formula was C4:C8 which is should have been C4:C7. My total
was in C8 that's why it would not calculate for me. Thanks for the help
though.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to getting text labels to show up in scatter chart. 0
lookup help. lookup result based on data in 2 columns 3
index_match 5
Vlookup and if formula 2
Worksheet Function required 2
Help with a date calculation 1
How to write XIRR formula on excel using different Year basis than 365. 5
How do I combine 2 data sets using date? 2

Top