Counting with multiple criteria - 1 label, date range, numerical range

[mkthoughts]

I really appreciate anyone who can help!!

Question: I want to count all the film titles that...
1. Studio Affiliated (Col B)
2. Release between 4/1/09-12/31/09 (col D)
3. Grossed between $2,000,000-4,000,000 (col F)

This is just a fraction of a much large file.

The answer is 2 films

<table x:str="" style="border-collapse: collapse; width: 281pt;" width="375" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" span="4" width="64"> <col style="width: 89pt;" width="119"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" id="_x0000_s1025" x:autofilter="all" x:autofilterrange="$A$1:$E$17" style="height: 12.75pt; width: 48pt;" width="64" height="17">Title</td> <td class="xl25" id="_x0000_s1026" x:autofilter="all" style="width: 48pt;" width="64">Distributor</td> <td class="xl25" id="_x0000_s1027" x:autofilter="all" style="width: 48pt;" width="64">category</td> <td class="xl26" id="_x0000_s1028" x:autofilter="all" style="width: 48pt;" width="64">Release Date</td> <td class="xl27" id="_x0000_s1029" x:autofilter="all" style="width: 89pt;" width="119">Inflation Adjusted Gross</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">Trailer Park Boys 2</td> <td class="xl27">Independent</td> <td class="xl27">Specialized</td> <td class="xl28" x:num="40081" align="right">9/25/09</td> <td class="xl29" x:num="1763950"> 1,763,950.00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">Bright Star</td> <td class="xl27">Apparition</td> <td class="xl27">Specialized</td> <td class="xl28" x:num="40072" align="right">9/16/09</td> <td class="xl29" x:num="1936829"> 1,936,829.00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">September Issue, The</td> <td class="xl27">Roadside Attractions</td> <td class="xl27">Specialized</td> <td class="xl28" x:num="40053" align="right">8/28/09</td> <td class="xl29" x:num="2908192"> 2,908,192.00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">My One And Only</td> <td class="xl27">Freestyle Releasing</td> <td class="xl27">major independent</td> <td class="xl28" x:num="40046" align="right">8/21/09</td> <td class="xl29" x:num="2231423"> 2,231,423.00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">Adam</td> <td class="xl27">Fox Searchlight</td> <td class="xl27">studio affiliated</td> <td class="xl28" x:num="40023" align="right">7/29/09</td> <td class="xl29" x:num="2221372"> 2,221,372.00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">In The Loop</td> <td class="xl27">IFC Films</td> <td class="xl27">Specialized</td> <td class="xl28" x:num="40018" align="right">7/24/09</td> <td class="xl29" x:num="2351317"> 2,351,317.00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">Cheri</td> <td class="xl27">Miramax</td> <td class="xl27">studio affiliated</td> <td class="xl28" x:num="39990" align="right">6/26/09</td> <td class="xl29" x:num="2715657"> 2,715,657.00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">Food, Inc.</td> <td class="xl27">Magnolia Pictures</td> <td class="xl27">Specialized</td> <td class="xl28" x:num="39976" align="right">6/12/09</td> <td class="xl29" x:num="4361985"> 4,361,985.00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">Brothers Bloom, The</td> <td class="xl27">Summit Entertainment</td> <td class="xl27">major independent</td> <td class="xl28" x:num="39948" align="right">5/15/09</td> <td class="xl29" x:num="3531756"> 3,531,756.00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">Summer Hours (Heure d'ete, L')</td> <td class="xl27">IFC Films</td> <td class="xl27">Specialized</td> <td class="xl28" x:num="39948" align="right">5/15/09</td> <td class="xl29" x:num="1647001"> 1,647,001.00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">Rudo y Cursi</td> <td class="xl27">Sony Pictures Classics</td> <td class="xl27">studio affiliated</td> <td class="xl28" x:num="39941" align="right">5/8/09</td> <td class="xl29" x:num="1827660"> 1,827,660.00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">Is Anybody There?</td> <td class="xl27">Story Island Entertainment</td> <td class="xl27">Specialized</td> <td class="xl28" x:num="39920" align="right">4/17/09</td> <td class="xl29" x:num="2026756"> 2,026,756.00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">Every Little Step</td> <td class="xl27">Sony Pictures Classics</td> <td class="xl27">studio affiliated</td> <td class="xl28" x:num="39920" align="right">4/17/09</td> <td class="xl29" x:num="1711722"> 1,711,722.00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">Sin Nombre</td> <td class="xl27">Focus Features</td> <td class="xl27">studio affiliated</td> <td class="xl28" x:num="39892" align="right">3/20/09</td> <td class="xl29" x:num="2536665"> 2,536,665.00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">Valentino: The Last Emperor</td> <td class="xl27">Vitagraph</td> <td class="xl27">Specialized</td> <td class="xl28" x:num="39890" align="right">3/18/09</td> <td class="xl29" x:num="1755134"> 1,755,134.00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">Two Lovers</td> <td class="xl27">Magnolia Pictures</td> <td class="xl27">Specialized</td> <td class="xl28" x:num="39857" align="right">2/13/09</td> <td class="xl29" x:num="3149034"> 3,149,034.00 </td> </tr> </tbody></table>

 

[Nogslaw]

If you are using Excel 2007, check out the new COUNTIFS() function. If you are using another version, try using a SUMPRODUCT() formula, like this:

=SUMPRODUCT((C1:C100="Studio Affiliated") * (D1:D100 >= 39904) * (D1:D100 <= 40178) * (E1:E100 >= 2000000) * (E1:E100 <= 4000000))

NOTES ABOUT THE FORMULA:
You said "Studio Affiliated" was in Col B, but your data appeared to present it in Column C, so I used C instead
You said Gross earnings was in Col F, but your data appeared to present it in Column E, so I used E instead
39904 is the numerical value for 4/1/09
40178 is the numerical value for 12/31/09
All criteria can be changed to cell references to make it more dynamic, and easier to change criteria values

 

[mkthoughts]

you are the dude!!!

Thanks very much for the answer and the promptness (and catching my mistakes)