Count a Range of cells if another range of cells meets criteria

**mjg060468** · 05-20-2013, 06:21 AM

Hi hope someone can help.

I have a spreadsheet which lists all the sales for a particular period from all our sales offices.

What I want to do is count the number of sales of a particular product from a particular sales office.

Have attached an image to show you.

So I want to create a formula that tells me that sales office AW has sold 1 x Product A and 2 x Product B and 1 x product D and so forth for each sales office.

I can tell that a product has been sold by the fact that the cells in columns D - G are not equal to 0.00

Can anyone help me please

sales.jpg

**oeldere** · 05-20-2013, 06:32 AM

Reading your problem i would suggest you to use a pivot table to get your result.

You get better help if you add an excel-file without confidentional information.

Please also add the desired (expected) result.

**dilipandey** · 05-20-2013, 06:32 AM

Hi mjg,

Instead of image, please upload an excel workbook and do mention your expected result. thanks.

Regards,
DILIPandey
<click on below * if this helps>

**mjg060468** · 05-21-2013, 05:30 AM

Hi both. Thanks for the reply.

Please find attached the demo spreadsheet showing the data and the reporting template I require

Thanks for your help

Regards