Countifs and Or combination: Need excel formula help please...

[pedie]

Hi, I have the current formula from yesterday's thread for sumif and or combination; but I need it for Countifs and Or combination too.

I want to count if col A, has "NY","LA" or "GA"
and col D has "May"
and Col C has "FEC" or "ORANGE"

Thanks in advance.

'SUM(SUMIFS($D$1:$D$27,$B$1:$B$27,"May",$C$1:$C$27,{"FEC","ORANGE"}))

 

[Ron Coderre]

Glad to help....and Good afternoon! (I'm in Boston)

 

[pedie]

Have a good afternoon, Ron!