Sumifs formula

[f4mdtwr]

Hello to all,

Need you help. I am trying to put together this report and cant seem to figure it out

location	Class	WeeksOH	WeeksOH_WSR	OnHandBalance	DEI1	ABC1	ABCrank
1	ACC	4.00	22.00	127	307.00	B	A
6	ACC	27.00	27.00	161	69.00	B	A
8	ACC	26.00	26.00	144	63.00	B	A
9	ACC	14.00	14.00	33	27.00	B	A
GLOBAL	ACC	52.00	52.00	8	0.00	D	A

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Total SKU count from GLOBAL location only
Exclude ACC from column "CLASS"
exclude less than 4 from "WeeksOH"
Count "A,B" in column ABC1

Im trying to put together a pie chart that shows my percentage between "A,B" compare to total sku count.

Thanks in advance for your help.

 

[pgc01]

Hi

For ex., assuming the data in rows 2:20, you can use:

=SUM(COUNTIFS(A2:A20,"GLOBAL",B2:B20,"<>ACC",C2:C20,">=4",G2:G20,{"A","B"}))