need formula help please!

[LIZEEY]

Hi, i need a formula for the below critera, i have tried all morning! the formula below works if i just have one critera for column f but returns a zero value when i add both 28 & 38. I'm lost! it doesnt take much i know!

sum the total count if column a contains "15" and column f contains "28" or "38" and column ap contains "30270" or "30290" or "30297"

=SUM(COUNTIFS($A$21:$A$15004,156,$F$21:$F$15004,{"28","38"},$AP$21:$AP$15004,{"30101","30270","30275","30290","30297","30550","30560"""}))

 

[Fluff]

When using 2 arrays one needs to be vertical & the other horiaontal, try

=SUM(COUNTIFS($A$21:$A$15004,156,$F$21:$F$15004,{"28";"38"},$AP$21:$AP$15004,{"30101","30270","30275","30290","30297","30550","30560"}))

 

[LIZEEY]

thank you universe for clever people!!! thanks so much! wishing i would have asked here 2 hours ago now

 

[Fluff]

You're welcome & thanks for the feedback.