# Count cells with a specific value based on multiple conditions

#### dax2000

##### New Member
Hi,

I'm trying to count cells with a specific value based on multiple conditions on an excel sheet using SUM / COUNTIFS functions. I want to avoid writing scripts.

 Color Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Red Item 1 Item 2 Item 2 Item 2 Item 1 Item 3 Item 3 Item 1 Item 1 Item 3 Item 2 Item 2 Green Item 3 Item 3 Item 3 Item 3 Item 1 Item 2 Item 2 Item 1 Item 2 Item 1 Item 1 Item 1 Blue Item 2 Item 1 Item 3 Item 1 Item 2 Item 3 Item 3 Item 2 Item 3 Item 2 Item 3 Item 2 Black Item 3 Item 2 Item 3 Item 2 Item 3 Item 1 Item 3 Item 1 Item 3 Item 1 Item 2 Item 3 Red Item 1 Item 3 Item 2 Item 3 Item 1 Item 2 Item 2 Item 2 Item 1 Item 2 Item 3 Item 1 Blue Item 1 Item 1 Item 2 Item 1 Item 2 Item 1 Item 3 Item 2 Item 2 Item 3 Item 1 Item 3 Black Item 2 Item 3 Item 3 Item 2 Item 3 Item 2 Item 1 Item 2 Item 1 Item 2 Item 1 Item 1

<tbody>
</tbody>

What I'm trying to do is to get how many ITEM 1 with red color are on Jan-16 / Feb-16 etc. Expect results should be 2.

Thanks,
John

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### Weazel

##### Well-known Member
maybe...

Excel 2010
ABCDEFGHIJKLM
1Color16-Jan16-Feb16-Mar16-Apr16-May16-Jun16-Jul16-Aug16-Sep16-Oct16-Nov16-Dec
2RedItem 1Item 2Item 2Item 2Item 1Item 3Item 3Item 1Item 1Item 3Item 2Item 2
3GreenItem 3Item 3Item 3Item 3Item 1Item 2Item 2Item 1Item 2Item 1Item 1Item 1
4BlueItem 2Item 1Item 3Item 1Item 2Item 3Item 3Item 2Item 3Item 2Item 3Item 2
5BlackItem 3Item 2Item 3Item 2Item 3Item 1Item 3Item 1Item 3Item 1Item 2Item 3
6RedItem 1Item 3Item 2Item 3Item 1Item 2Item 2Item 2Item 1Item 2Item 3Item 1
7BlueItem 1Item 1Item 2Item 1Item 2Item 1Item 3Item 2Item 2Item 3Item 1Item 3
8BlackItem 2Item 3Item 3Item 2Item 3Item 2Item 1Item 2Item 1Item 2Item 1Item 1
9
10ColorItemStartEnd
11RedItem 116-Jan16-Feb2

<tbody>
</tbody>
Sheet1

Worksheet Formulas
CellFormula
F11=SUMPRODUCT((A2:A8=A11)*(B2:M8=B11)*(B1:M1>=C11)*(B1:M1<=D11))

<tbody>
</tbody>

<tbody>
</tbody>

Replies
1
Views
86
Replies
1
Views
187
Replies
1
Views
160
Replies
4
Views
170
Replies
5
Views
183

1,190,653
Messages
5,982,126
Members
439,756
Latest member
alice128

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back