SUMIFS 1 criteria 36 columns URGENT

[Karolina]

Trying to add 36 columns based on 1 criteria, and return the result. example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]product[/TD]
[TD]status[/TD]
[TD]units/$[/TD]
[TD]wk 1[/TD]
[TD]wk 2[/TD]
[TD]total units[/TD]
[TD]total $[/TD]
[TD]wk 1[/TD]
[TD]wk 2[/TD]
[TD]ttl[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]allocated[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]$10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]released[/TD]
[TD]$20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]allocated[/TD]
[TD]7[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]$50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]released[/TD]
[TD]$70[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

area from units/$ to ttl $ repeats 36 times. I need to add the 36 columns under "units/$" based on either allocated or released criteria

right now I'm using multiple sumifs (a lot of formula) how can I shorten?

this is what I use for "released" - it's too much.

=SUMIFS(Z$3:Z$375,X$3:X$375,"released",F$3:F$375,F$4)+SUMIFS(AG$4:AG$376,X$3:X$375,"released",F$4:F$376,F$4)+SUMIFS(AN$4:AN$376,X$3:X$375,"released",F$4:F$376,F$4)+SUMIFS(AU$4:AU$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(BB$4:BB$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(BI$4:BI$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(BP$4:BP$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(BW$4:BW$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(CD$4:CD$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(CK$4:CK$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(CR$4:CR$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(CY$4:CY$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(DF$4:DF$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(DM$4:DM$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(DT$4:DT$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(EA$4:EA$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(EH$4:EH$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(EO$4:EO$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(EV$4:EV$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(FC$4:FC$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(FJ$4:FJ$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(FQ$4:FQ$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(FX$4:FX$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(GE$4:GE$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(GL$4:GL$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(GS$4:GS$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(GZ$4:GZ$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(HG$4:HG$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(HN$4:HN$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(HU$4:HU$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(IB$4:IB$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(II$4:II$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(IP$4:IP$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(IW$4:IW$376,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(JD$3:JD$375,X$4:X$376,"released",F$4:F$376,F$4)+SUMIFS(JK$4:JK$376,X$4:X$376,"released",F$4:F$376,F$4)

 

[Jonmo1]

Welcome to the board.

Try

=SUMPRODUCT((X$3:X$375="released")*(F$3:F$375=F$4)*(Z$2:JK$2="units/$")*(Z$3:JK$375))

 

[Karolina]

Welcome to the board.

Try

=SUMPRODUCT((X$3:X$375="released")*(F$3:F$375=F$4)*(Z$2:JK$2="units/$")*(Z$3:JK$375))

Worked like a charm! THANK YOU!! and Happy to be here and learn more Excel!