Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula too long
Have run into a problem using excel - it is telling me the formula I am using is too long and will not allow additional data to be entered. The excel file is a payroll where worksheets are used to calculate the pay. That information is then transferred to the Master worksheet (gross summary) then certain fields within the worksheets are selected as part of the formula on the master. All worked fine until now when trying to add infomation to the formula due to additional worksheets being added ... the comment formula too long will not allow additional data and therefore unable to get the master sheet to balance. The formula being used is as follows - =Eyears!C16+Eyears!C19+Eyears!C22+ and picks up data from another 30+ employees. Any help / suggestions would be appreciated! -- glenlisa ------------------------------------------------------------------------ glenlisa's Profile: http://www.excelforum.com/member.php...o&userid=26069 View this thread: http://www.excelforum.com/showthread...hreadid=394063 |
#2
|
|||
|
|||
Glenlisa,
It sounds like you need to break it up a little. You can use intermediary cells with subtotals for example, and then have your master cell add up the subtotals. Alternatively, you could use vba code to process the cell containing the extra long formula. It might help if you pasted the whole formula you are trying to use. It's sometimes easier to envision the solution when you can see the whole problem. :) Roy -- (delete .nospam) "glenlisa" wrote: Have run into a problem using excel - it is telling me the formula I am using is too long and will not allow additional data to be entered. The excel file is a payroll where worksheets are used to calculate the pay. That information is then transferred to the Master worksheet (gross summary) then certain fields within the worksheets are selected as part of the formula on the master. All worked fine until now when trying to add infomation to the formula due to additional worksheets being added ... the comment formula too long will not allow additional data and therefore unable to get the master sheet to balance. The formula being used is as follows - =Eyears!C16+Eyears!C19+Eyears!C22+ and picks up data from another 30+ employees. Any help / suggestions would be appreciated! -- glenlisa ------------------------------------------------------------------------ glenlisa's Profile: http://www.excelforum.com/member.php...o&userid=26069 View this thread: http://www.excelforum.com/showthread...hreadid=394063 |
#3
|
|||
|
|||
The breaking up of the formula works as it should! Thanks -- glenlisa ------------------------------------------------------------------------ glenlisa's Profile: http://www.excelforum.com/member.php...o&userid=26069 View this thread: http://www.excelforum.com/showthread...hreadid=394063 |
#4
|
|||
|
|||
Hi!
=Eyears!C16+Eyears!C19+Eyears!C22+ If the pattern of every 3rd cell is constant: =SUMPRODUCT(--(MOD(ROW(Eyears!C16:C150),3)=1),Eyears!C16:C150) Biff "glenlisa" wrote in message ... Have run into a problem using excel - it is telling me the formula I am using is too long and will not allow additional data to be entered. The excel file is a payroll where worksheets are used to calculate the pay. That information is then transferred to the Master worksheet (gross summary) then certain fields within the worksheets are selected as part of the formula on the master. All worked fine until now when trying to add infomation to the formula due to additional worksheets being added .. the comment formula too long will not allow additional data and therefore unable to get the master sheet to balance. The formula being used is as follows - =Eyears!C16+Eyears!C19+Eyears!C22+ and picks up data from another 30+ employees. Any help / suggestions would be appreciated! -- glenlisa ------------------------------------------------------------------------ glenlisa's Profile: http://www.excelforum.com/member.php...o&userid=26069 View this thread: http://www.excelforum.com/showthread...hreadid=394063 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
long formula obscures cell view | Excel Discussion (Misc queries) | |||
Formula too long | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |