Copying cell information [Closed]

Report
-
Posts
2776
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 26, 2021
-
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

Posts
2776
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 26, 2021
465
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!