Hello Everyone,
I am new to this thread and also to Excel Formulas.
I have data where I have to Increment/Count a number if the condition is met otherwise subtract the number by 1.
For example:
For ColC:
For each "Consumed" value in ColB increment the value by 1 in ColC. If there is a "not_consumed" value in ColB then subtract 1. For value"partially_consumed", do nothing or ignore.
Expected Result:
I was able to make the count part work but I am not sure how to subtract the value if it is "not_consumed".
Formula: =COUNTIFS(ColA$2:ColA2; "App_*"; ColB$2:ColB2;"Consumed")
My Result is:
1
2
3
4
4
5
5
5
5
I am new to this thread and also to Excel Formulas.
I have data where I have to Increment/Count a number if the condition is met otherwise subtract the number by 1.
For example:
ColA | ColB | ColC |
App_1 | Consumed | |
App_2 | Consumed | |
App_3 | Consumed | |
App_4 | Consumed | |
Base_1 | not_consumed | |
App_5 | Consumed | |
Base_3 | not_consumed | |
App_5 | partially_consumed | |
Base_4 | not_consumed |
For ColC:
For each "Consumed" value in ColB increment the value by 1 in ColC. If there is a "not_consumed" value in ColB then subtract 1. For value"partially_consumed", do nothing or ignore.
Expected Result:
ColA | ColB | ColC |
1 | ||
2 | ||
3 | ||
4 | ||
3 | ||
4 | ||
3 | ||
Do nothing | ||
2 |
I was able to make the count part work but I am not sure how to subtract the value if it is "not_consumed".
Formula: =COUNTIFS(ColA$2:ColA2; "App_*"; ColB$2:ColB2;"Consumed")
My Result is:
1
2
3
4
4
5
5
5
5