Counting number of bookings where revenue between set values

[mr_hiboy]

Hi,


I'm looking to count the number of bookings that revenue value falls between a set range.


Tried sumifs and sumproduct as think it may need an array, but going round in circles.


More info on the attached.

https://dl.dropboxusercontent.com/u/9071274/Revenue%20between%20values.xlsx


Appreciate you help


Paul

 

[Hui]

First, Change M4 to 600 and M5 to 9999


Then in Report!C6:

=COUNTIFS(Bookings!$B$2:$B$1555,$B6,Bookings!$D$2:$D$1555,">"&C$4,Bookings!$D$2:$D$1555,"<="&C$5)

or

=SUMPRODUCT((Bookings!$D$2:$D$1555>C$4)*(Bookings!$D$2:$D$1555<=C$5)*(Bookings!$B$2:$B$1555=$B6))


Be careful with the > as a >= will include 0 in the counts in Column C