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.
<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
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
