I need some help with creating a formula in Excel. Can someone tell me if there is a cap on how many cells you can tell a cell to pick up in a formula? I’m trying to create a formula in a cell in the front sheet of a workbook that picks up the corresponding cells in back sheets in the same book, but as soon as I’ve entered 30 an error message comes up saying ‘you have entered too many arguments for this function’…….

Can anyone tell me how I can enable it to let me add more?