Copying cell information

Closed

Excel numpty - Aug 25, 2015 at 02:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator 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.

Copying cell information
Protect pdf from copying - Guide
Based on the cell values in cells b77 ✓ - Excel Forum
Excel function question - Excel Forum
If cell contains date then return value ✓ - Excel Forum
Excel: If Date =, then enter a value ✓ - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator 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

If a cell contains any text then add a value

If cell = date return yes or no.

Highlight cell if another cell contains specific text

Counting cells containing only numbers

Similar discussions

Subscribe To Our Newsletter!