Forum Discussion
Help with array in a SUMIFS formula
Hi everyone, it is my first post in this community. I am trying to work with a very simple array formula as a criteria for a SUMIFS formula without success. My data is as bellow Col...
Just to illustarte how array works
=MMULT(TRANSPOSE((A1:A4="a")+(A1:A4="c")),B1:B4)Result is the same