Hi

Do you mean
=SUM(Sheet1:Sheet10!A5)
This will sum the values of cell A5 across all 10 sheets.

Regards

Roger Govier


ErwinR wrote:
Hello. How can I get in a worksheet all the values of let's say cell A5
or column B from several different worksheets?