Im using the following forumla to add numbers from 3 different sheets. Each sheet has 6 columns that are filled in from right to left at different times. The left most column with a number in it is always considered the most up to date. The test is always if row 34 in each column does not equal 0. If it does it needs to move to the "earlier" column and test that one. There will always be something in the right most column. Im looking for something more efficient and more importantly shorter as I need to further alter this and length of the formula will be an issue for users with ealier versions of excel. I am using 2010 but needs to be compatiable with 2000. Thanks!!
Code:
=IF(FEB!$C$34=0,IF(FEB!$D$34=0,IF(FEB!$E$34=0,IF(FEB!$F$34=0,FEB!$G41,FEB!$F41),FEB!$E41),FEB!$D41),FEB!$C41)+IF(MAR!$C$34=0,IF(MAR!$D$34=0,IF(MAR!$E$34=0,IF(MAR!$F$34=0,MAR!$G41,MAR!$F41),MAR!$E41),MAR!$D41),MAR!$C41)+IF(APR!$C$34=0,IF(APR!$D$34=0,IF(APR!$E$34=0,IF(APR!$F$34=0,APR!$G41,APR!$F41),APR!$E41),APR!$D41),APR!$C41)
