Copying to cell information

Closed

ExcelNumpty Posts 2 Registration date Monday August 24, 2015 Status Member Last seen August 26, 2015 - Aug 24, 2015 at 11:00 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

Copying to cell information
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Highlight cell if another cell contains text ✓ - Excel Forum
Count if cell contains number - Excel Forum
Excel if cell contains date ✓ - Office Software Forum

Subscribe To Our Newsletter!