count records depending on selected month

[smuller74]

Hello all,

I'm getting confused looking for the correct formula and I hope somebody can help...

I'm using this array formula currently to count records:

=COUNT(IF((sheet2!F2:F5000=55)*(D22="january")*(sheet2!Q2:Q5000=1);(sheet2!A2:A5000)))

(D22="january") - In box "D22" I placed a drop-down to select a month.

This formula is working for "january" (= sheet2!Q2:Q5000=1) but how do I adjust the formula to make sure the calculations are correct per month if I change the month in "D22"?

Thanks for any help or any idea.

Best regards

 

[Andrew Poulsom]

Try:

=AANTAL(ALS((debiteurnummer!F2:F5000<>"")*(debiteurnummer!F2:F5000=0)*(debiteurnummer!Q2:Q5000=MAAND(("1"&F22)+0)*(debiteurnummer!A2:A5000=H4));(debiteurnummer!A2:A5000)))

 

[smuller74]

That's it, thanks again Andrew!