Forum Discussion
Solved
Way to make BYROW and BYCOL work together
I have the following sample dataset below: Then I can run a SUMIF that can be dynamic down or across by using BYROW and BYCOL respectively: But I need that SUMIF to be simultaneously dynamic down A...
There's also MMULT, which can be highly efficient, but tricky to learn:
=MMULT(--(TOROW(A2:A12)=A22#),--B2:G12)See attached...
There's also MMULT, which can be highly efficient, but tricky to learn:
=MMULT(--(TOROW(A2:A12)=A22#),--B2:G12)See attached...
Thanks!