Question

someone please help me on excel

Answer 1

adjust the references in the formulas of rows 12 and 13 by adding the sheet reference

Answer 2

Your question is somewhat unclear, but after examining the spreadsheet what it looks like you are talking about is adding the page reference to the formulas on rows 12 &13 of the Jan-Jun sheet.

The Jul-Dec sheet already has sheet references, so you can use these as model, but so you understand what you are doing I'll explain it a little bit.

You can reference data and formulas from other sheets in a workbook by using the Bang (!). When you use the ! you are telling excel to look on the specified page for the contents of the speified cell (i.e. Jan-Jun!E12). This is convenient in that you can easily reference cells from other sheets that contain formulas or data that you need.

This is usually used between sheets, but looking at what you have so far the Jul-Dec sheet already contains references in the formulas albeit they only reference that sheet. My guess would be that you need to do the same thing to the Jan-Jun sheet. If this is correct, just use the Jul-Dec sheet as your model and change the formulas on the other sheet so that they look similar, but with references to the Jan-Jun sheet.