Need help getting a count but I dont know what formula to use.
In cells D4:F4 there is a validation list which contains days of week (M, T, W, TH, F). The header is Call 1, Call 2 and Call 3. I need to count how many calls were monitored.
For example
D4 = TH
E4 = M
F4 = T
so the total count of calls monitored should equal 3.
In cells D4:F4 there is a validation list which contains days of week (M, T, W, TH, F). The header is Call 1, Call 2 and Call 3. I need to count how many calls were monitored.
For example
D4 = TH
E4 = M
F4 = T
so the total count of calls monitored should equal 3.
