Sumifs and Countifs limitations with ors and AND: Excel formulas:

[pedie]

Hi, below is the current excel formula.
Is there any limitations with Sumifs and Countifs with or combinations
'=SUM(COUNTIFS(B2:B27,"May",C2:C27,{"FEC";"ORANGE"},A2:A27
,{"NY","GA","LA"}))

for exampel if I want it this way {"NY","GA","LA","AZ","TX"})), will it still give me accurate answer?


Thanks in advance.

 

[Matty]

Hi Aladin,

Thanks a lot for taking the time to put that together; it's helped my understanding of how Excel is behaving in such circumstances.

Thanks again - much appreciated.

Matty

 

[Aladin Akyurek]

Hi Aladin,

Thanks a lot for taking the time to put that together; it's helped my understanding of how Excel is behaving in such circumstances.

Thanks again - much appreciated.

Matty

Hi Matty: I appreciate the feedback.