Software

Ask something
Discussion Locked

Can I simplify this array

0 helpful
3 replies

by tony.wright2

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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))

3 replies

by opatzg9

try putting the "Y" "C" at the top of the spreadsheet for determination instead of the bottom.

This discussion is closed to new replies.