Complex, Countif 2 conditions met

[msiegal]

Hi All,

I am looking to combined these two countif statements below to get a new =countif(Statement1 AND Statement2), I can't seem to figure out a formula that will work.. is this possible? Or is there a better way to do this?

Statement 1 =COUNTIFS('Paste Key Survey Results'!F:F, "Yes")
Statement 2 =COUNTIF('Paste Key Survey Results'!D:D,">119")-COUNTIF('Paste Key Survey Results'!D:D,">=2603")

Any and all advice is appreciated!

Thanks,
Marly

 

[msiegal]

Ok I finally figured it out.. I need to use a vlookup to identify the store number region and then once I have a column with the just the 3 regions I can do a count for the regions! Sorry I struggled describing this but I really appreciate your help and efforts on my behalf

 

[Aladin Akyurek]

Ok I finally figured it out.. I need to use a vlookup to identify the store number region and then once I have a column with the just the 3 regions I can do a count for the regions! Sorry I struggled describing this but I really appreciate your help and efforts on my behalf

The art of asking questions and getting answers consist really on a good, small sample along with the desired values that must obtain.