If you need to get the sum across multiple worksheets, you can use one of the less-known Excel feature called 3D referencing. With 3D referencing, you can refer to the same cell in multiple worksheets, and can also use this in formulas such as the SUM or AVERAGE, or COUNT. In this short tutorial, I ... Read more
from Online Excel Tips – Blog – Trump Excel https://ift.tt/ekcH7z5
0 Comments