Count data cells in Excel based on multiple criteria 2

[adfo]

I have an excel table with three fields (file uploaded and link attached). I need to generate tables to count data cells based on multiple criteria within the table. The data and the tables are described in the attached excel file. I think this could be accompolished by using either excel built-in functions or VBA. I prefer the excel functions if possible. Thanks

 

[Gavona]

I haven't looked at your file but the DCount function sounds designed to do the trick.

Gavin

 

[Gavona]

Ok Sumproduct simpler in your situation. In cell D11 and copied down and across:
=SUMPRODUCT(--(Data!$A$2:$A$2929>=Table!$B11),--(Data!$A$2:$A$2929<=Table!$C11),--(Data!$B$2:$B$2929>=Table!D$9),--(Data!$B$2:$B$2929<=Table!D$10))

Now I would actually use named ranges within the formula...

Gavin

 

[SkipVought]

hi,

Using Named Ranges for your DATA...
[tt]
Table 1
=SUMPRODUCT((A>=$B11)*(A<=$C11)*(B>=D$9)*(B<=D$10))

Table 3
=SUMPRODUCT((A>=$B25)*(A<=$C25)*(B>=D$9)*(B<=D$10)*(C_>=45)*(C_<=180))
[/tt]

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]