Hi all,
I would appreciate if you could please help me with an excel formula for below;
I need to count the number of profitable days when there are multiple entries for the same day with profits and losses. if the day's total sale is negative, need to consider that as a loss day. Need to count a day only when the day's total is positive.
for example, for the below data, I want a formula to say there are only 3 profitable days. How can I get that result from a formula.
please let me know.
I would appreciate if you could please help me with an excel formula for below;
I need to count the number of profitable days when there are multiple entries for the same day with profits and losses. if the day's total sale is negative, need to consider that as a loss day. Need to count a day only when the day's total is positive.
for example, for the below data, I want a formula to say there are only 3 profitable days. How can I get that result from a formula.
please let me know.
Date | Sale |
1/11/2023 | 63 |
1/11/2023 | 11 |
2/11/2023 | -12 |
2/11/2023 | -34 |
2/11/2023 | -29 |
2/11/2023 | -37 |
4/11/2023 | -68 |
6/11/2023 | -46 |
6/11/2023 | 28 |
6/11/2023 | 12 |
6/11/2023 | 70 |
7/11/2023 | 32 |
7/11/2023 | 16 |
7/11/2023 | 13 |
7/11/2023 | 9 |
7/11/2023 | 25 |
7/11/2023 | -36 |
9/11/2023 | 3 |
9/11/2023 | -2 |
9/11/2023 | 7 |
9/11/2023 | -22 |
9/11/2023 | -4 |
10/11/2023 | 41 |
10/11/2023 | -22 |
10/11/2023 | -59 |