Summing across multiple worksheets in the same workbook

[JSEMP]

Hi

I am pulling my hair out with this. I am sure there is a simple answer.

I am trying to sum cell AM4 across multiple worksheets labelled months APRIL-MARCH (financial year).

The Cell AM4 in each worksheet currently has the following formula =SUM(AD4,U4,L4,C4) (yes i selected the cells backwards and could have just used cell+cell+cell).

The totals worksheet I have created is to, as the name suggest, total the other worksheets.

The formula I am using to sum the cell AM4 across the 12 monthly worksheets is =SUM(APRIL:MAR!AM4)

The resulting value in that box is 0, despite every worksheet summing correctly and having its own value.

What am I doing wrong?

 

[energman58]

Ah! Check the status bar on the bottom left of your screen. It normally says "ready" - next to that it may give an address of the circular reference (if it is on the active sheet) or just say something like "Circular" in which case it is on a different sheet and you will have to go through each tab to find it. I suspect that this is the cause of your problems - you probably just need to resolve the circular reference(s)

 

[energman58]

Glad you sorted it in the end - those kind of issues are often hard to spot especially if they are in the middle of a load of formulae

 

[JSEMP]

Thanks! I will remember that for the future. So frustrating when you know you have everything correct as it should be, but simply forget to look in the corner at the status...