sonam_verma15's blog
Formula for multiple entries
Submitted by sonam_verma15 on 22 February, 2012 - 14:18Basically I have a column which has different buyer codes.
Eg:
EC51
EC38
EC51
EC38
EC74
I then have another column which contains either a hit or a miss.
hit
miss
miss
miss
hit
I need a formula which can count a particular buyer code with either a hit or a miss.
E.g. Buyer EC51 will have a total of 7 misses all together. I tried count if, but count if cant support multiple criteria. Please help!
»
- 2 comments
- 4048 reads
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago