Hi,
I have data as below. What I want to get is result same as last column. Could you pls advise which formul should be?
Logic: count each order how many time late No, how many time late Yes.
Thanks.
I have data as below. What I want to get is result same as last column. Could you pls advise which formul should be?
Logic: count each order how many time late No, how many time late Yes.
Thanks.
Ví dụ các hàm excel.xlsx | ||||||
---|---|---|---|---|---|---|
R | S | T | U | |||
23 | Order# | Submit date | Late submission? | Result s/b | ||
24 | A | 1-Dec | No | 1 | ||
25 | B | 1-Dec | No | 1 | ||
26 | A | 2-Dec | Yes | 1 | ||
27 | B | 2-Dec | Yes | 2 | ||
28 | C | 1-Dec | No | 1 | ||
29 | B | 3-Dec | Yes | 0 | ||
30 | C | 2-Dec | Yes | 1 | ||
31 | A | 1-Dec | No | 0 | ||
Sheet1 |