Hoping someone can help with an apparent formula problem I'm having. I'm
working with a very simple spreadsheet showing different projects and their
monthly costs each month over the course of a year (cost figures cut and
paste from Microsoft Project)

I want to put a simple "sum" formula at the bottom of each month column to
add up all the costs for each month but when I put in the formula
(=SUM(B32:B79)) a green trianlge appears in the top left of the cell which
which tells me that the forumla omits adjacent cells (not sure what this
means), and I can't cut and paste the total figure to another sheet as it
pastes REF! I can click another option that lets me "update the formula to
include cells" but when I do this the total for each column that it gives me
is incorrect.

Does anyone have any idea how to rectify this.

Many thanks.
--
Project for Work, Cigars for Pleasure