General discussion
February 5, 2003 at 07:25 PM
tony.wright2

Can I simplify this array

by tony.wright2 . Updated 23 years, 6 months ago

I have multiple copies of this array formula on my excel 2000 worksheet. This makes the worksheet very slow when changing exsisting data or adding new data. Is there any way of simplifying and therefore making the calculations quicker

=SUM(($K35:$K65536=”Y”)*($L35:$L65536=”C”)*(EC35:EC65536))

This discussion is locked

All Comments