IT support

HI 

Came across this web and I have an excel problem

=COUNTIFS(B4:B6,”>10″,B4:B6,”<=13″)  works

 

=COUNTIFS(B4:B6,”>10″,B:B,”<=13″)  error

 

so why B:B cannot be used?  what is the main difference between B4:B6 (with row no.)and B:B (without row no.)

By: alex

Leave a Reply

Your email address will not be published. Required fields are marked *