Use Countif with If(And

[lsofia]

I'm trying to write a formula that will count the number of locations within a specific size that have net revenue margins within a specific range. I get an error on the formula below so I know it's wrong but hopefully you can get the gist of what I'm trying to write:

Thanks!

=IF(AND('AE DETAIL'!$W:$W>10,'AE DETAIL'!$W:$W<=20),COUNTIF('AE DETAIL'!$Q:$Q,"7*"))

 

[Jonmo1]

If you have XL2007+ you can use countifS

=COUNTIFS('AE DETAIL'!$Q:$Q,"7*",'AE DETAIL'!$W:$W,">10",'AE DETAIL'!$W:$W,"<=20")