Hi,

Can you clarify what you mean please.

When you say how do you apply it to the whole workbook are you wanting to know how you can copy one of the formulae I gave you to each sheet in the workbook?

If so are you saying that the number of rows which need summing on each worksheet are all different - or may be different?

As I said if you use the first formula you don't need to worry about whether the number of rows varies - just sum the whole column. Otherwise you'll need to change the row range in the formula with a macro. And in which case what should be the trigger for that macro? A button push, a change in a cell (which cell?).

As I say if the first formula is acceptable then it just needs copying to each sheet. In which case the simplest way, which avoids writing a macro is to Group all relevant sheets by holding down the Ctrl key and clicking each sheet tab name with a mouse click, then type the formula into J8 on one sheet (any will do) and it will be entered into all the other Grouped sheets.