I read a previous entry where you explained how to shorten a formula...it
didn't really pertain to my needs. Can someone help? I have many g/l
accounts that I need to include in my formula. How can I shorten it. This is
an example of a formula that I have and it is one of the shortest ones I have.
...

=SUM(IF(VALUE(Sheet1!$A$2:$A$5481)=1,IF(VALUE(She et1!$B$2:$B$5481)=340010,IF(VALUE(Sheet1!$B$2:$B$ 5481)<=340060,Sheet1!$K$2:$K$5481,0),0),0)*-1,IF(VALUE(Sheet1!$A$2:$A$5481)=1,IF(VALUE(Sheet1 !$B$2:$B$5481)=341010,IF(VALUE(Sheet1!$B$2:$B$548 1)<=341060,Sheet1!$K$2:$K$5481,0),0),0)*-1)
--
Michelle