Count query

[mr_hiboy]

Hi all,

run into a brick wall with doing some counts.

I'm looking to create a count based on a few columns. So been using countifs, all good. But now as well as one value from two different columns i want to look for a range of values in another columns.
https://dl.dropboxusercontent.com/u/9071274/Count Query.xlsx
Any pointers would be great.

thanks

 

[bobhc]

Some members cannot access upload sites, can you not use the forums upload

 

[SirJB7]

Hi, mr_hiboy!

There are many ways to solve it as you guessed in your implied question at column L. Just to keep the format of your K7 cell formula, try this in K9:
=CONTAR.SI.CONJUNTO($B$6:$B$9;$G$5;$C$6:$C$9;$G$6;$D$6:$D$9;">="&$G$7)-CONTAR.SI.CONJUNTO($B$6:$B$9;$G$5;$C$6:$C$9;$G$6;$D$6:$D$9;">"&$G$6) -----> in english: =COUNTIFS($B$6:$B$9,$G$5,$C$6:$C$9,$G$6,$D$6:$D$9,">="&$G$7)-COUNTIFS($B$6:$B$9,$G$5,$C$6:$C$9,$G$6,$D$6:$D$9,">"&$G$6)

Just take care of placing the lower value in G7 and the higher in I7 cells.

Regards!

 

[mr_hiboy]

Thank you SirJB7, you confised me a little by using >G6 rather than I7, but I got ya!

Spot on and I understand it!

Thanks for swift response, appreciated.

 

[SirJB7]

Hi, mr_hiboy!
Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.
Regards!