Question

In cell C4 of the PB workbook, enter a formula, using external cell references , that add together the values from C4 in all sheets of the PB Jan to March

Answer 1

To add together the values from cell C4 in all sheets of the PB Jan to March, you can use the following formula in cell C4 of the PB workbook:

=SUM('PB Jan:PB Mar'!C4)