Hello,
I have a table with store names in a row and store items in a column. Based on the quantity of items on hand, I am trying to see how many stores can be serviced. The meat of the table has the quantity each store needs for each item.
I am trying to come up with a count-if formula that will count the store shortages. I have been able to have conditional formatting highlight the shortages automatically. However, I can't figure out how to count the red cells.
it won't let me attach a workbook, so i pasted my table below. I assume I have to do an single-cell array, but I am completely lost. The purple numbers are what I want the formulas to output. Any ideas?
Thank you for your time
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
I have a table with store names in a row and store items in a column. Based on the quantity of items on hand, I am trying to see how many stores can be serviced. The meat of the table has the quantity each store needs for each item.
I am trying to come up with a count-if formula that will count the store shortages. I have been able to have conditional formatting highlight the shortages automatically. However, I can't figure out how to count the red cells.
it won't let me attach a workbook, so i pasted my table below. I assume I have to do an single-cell array, but I am completely lost. The purple numbers are what I want the formulas to output. Any ideas?
Thank you for your time
A | B | C | D | E | F | G | |
1 | Item Qty | Store 1 | Store 2 | Store 3 | Store 4 | Store 5 | |
2 | |||||||
3 | 1 | 2 | 2 | 4 | 4 | ||
4 | Item 1 | 4 | 1 | 1 | 1 | 1 | 1 |
5 | Item 2 | 4 | 1 | 1 | 1 | 1 | 1 |
6 | Item 3 | 1 | 1 | 1 | 1 | 1 | 1 |
7 | Item 4 | 0 | 1 | 1 | 1 | 1 | 1 |
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
Last edited: