I want to account for the total number of assets on hand, but there seems to be a duplicate problem I can't solve. I've got a total of 45 items under 2 customers, with 7 cells formulating for all items status/location. The current formula I'm using to count the totals is =SUM(M8,P8,P6,O6,M6+COUNTIF(E5:E49,"DL10"))-2. This is pulling from a large table, and since my formula wants to count the AWM and DL10s, its double counting items labeled with both. How can I count only one where AWM takes priority?
All cells contain formulas to count respective cells matching criteria. Table1=T1
<tbody>
</tbody>
All cells contain formulas to count respective cells matching criteria. Table1=T1
A1 | M6 | O6 T1(F5:F49) | P6 | T1(E5:E49) | |
Total (45) | INW | AWM | AWP | DL10 | |
47 | 2 | 3 | 5 | 7 | |
M8 -> | Customer 1 | Customer 2 | <- P8 | ||
15 | 13 |
<tbody>
</tbody>
Last edited: