General discussion

Locked

Can I simplify this array

By Tony.Wright2 ·
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 conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Can I simplify this array

by opatzg In reply to Can I simplify this array

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

Collapse -

Can I simplify this array

by Tony.Wright2 In reply to Can I simplify this array

Poster rated this answer

Collapse -

Can I simplify this array

by Tony.Wright2 In reply to Can I simplify this array

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums