Previous Topic Next Topic

Copying cell information

Closed
Excel numpty - Aug 25, 2015 at 02:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response