Home » Blogs » sonam_verma15's blog

Formula for multiple entries

Submitted by sonam_verma15 on 22 February, 2012 - 14:18

Basically 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!

»
Vishesh's picture

Use =SUMPRODUCT((A1:A10="EC51

Submitted by Vishesh on 22 February, 2012 - 16:17.

Use
=SUMPRODUCT((A1:A10="EC51")*(B1:B10="hit"))

Excel 2007 has countifs.

»

Thank you it works

Submitted by sonam_verma15 on 24 February, 2012 - 09:46.

Thank you it works

»