Excel 2007 : Filter in DCOUNT function

[softindo]

I created a dummy work to learn about DCOUNT function (file is attached). There are two sheets which

Sheet1 consists of required information and criteria.

Sheet2 consists of DCOUNT formula to count number of cells that contain numbers in columns of records that match conditions I specified on Sheet1 G1:N8.

My question, is that possible to filter number (cell B3 on Sheet2) by category "Smartphone" from (Sheet1 B2:B9) without using Advanced Filter? so expected result counting number on cell B3 would be 2.

Thank you for any help

[dilipandey]

Hi Softindo,

It is done, see the attachment and look for yellow cell in the answer set. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>