Copying cell information

Closed
Excel numpty - Aug 25, 2015 at 02:57 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Aug 27, 2015 at 11:11 AM
Hello,
I would like to copy + add up the numbers in the cells. However when I change the filters, the numbers brought through change. The information is in the same file it is just on separate tab/sheet.
The example is below.
='TA 2015-16'!AI5+'BP 2015-16'!AI5+'RP 2015-16'!AI5


Please help, I would be very grateful for any suggestions.


Thank you all in advance.


Regards excel numpty.

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Aug 27, 2015 at 11:11 AM
Hi Excel numpty,

Let the following pictures guide you towards the solution to your question and let us know if this works for you:

Unfiltered:


Filtered:


Best regards,
Trowa
0