Snasui Excel Forum

Posted: **Wed Oct 13, 2021 9:07 pm**

Hi dear,

I need to sum values base on criteria by row and column.
I attached a template with expect results

Thanks

Posted: **Wed Oct 13, 2021 9:50 pm**

...

B10

=SUMPRODUCT((TEXT($B$1:$K$1,"mmm")=B$9)*($A10=$A$2:$A$6)*$B$2:$K$6)

Norkaz

Posted: **Thu Oct 14, 2021 7:31 am**

TY.it works

2d array