Please can someone help?

I am currently working on a workbook, which has four worksheets in.

I am having difficulty adding two cells together.

The first set of cells is on workbook called Register, the cell that has the
additon in it is

Cell L21 contains =COUNTIF(B21:K21,"Yes").
This returns a value of however many times it has counted "Yes" in that range.
. This cell is formatted as General

I then have another workbook called Additional Hours

I have some cells with numbers in G3:G5, these contain a number which has
been calculated between by first cell - second cell to give the answer in the
third cell, that has been formated to General

I then add up all three cells to give the correct answer in the fourth cell

If the fifth cell, I refer to the Cell L21 from Register, this gives me the
correct
value

I then try and add the fourth cell and the fith cell together, to get an
answer. However ther answer is only the value from the fourth cell and not
the fourth of the fifth.

Please help.

Please reply to this thread or off list to

mark[dot]a[dot]lombardo[at]btinternet[dot]com

Thanks in advance

Mark