array worksheet

  1. O

    3d arrays

    Is there anyway to use the third dimension as a vector. I know I can do {=sum((a2:a6="x")*b2:b6)}, how can I do something like: ={sum((sheet1:sheet6!b6="x")*b2:b6)} or ={sum((sheet1:sheet6!b6)*(a1:g1))}

Some videos you may like

This Week's Hot Topics

Top