How to count cell combinations

  • Thread starter Thread starter portengine
  • Start date Start date
P

portengine

I'm looking for the formula to count the number a specified set of
combinations appears in the table. Cells A1:A7 would vary with entries
of L or R. Cells B1:B7 would vary with entries of S, C or B.

In Cell B8 would be result of how many times there was a combination
of an A cell having an 'L' and a B cell having a C.

I'd also be looking for other specified combinations but once I have
the basics down I can adjust the search criteria in the formula. Thank
you for any assistance.
 
Let's say you have L in D1 and C in E1

=sumproduct(--($A$1:$A$7=D1),--($B$1:$B$7=E1))

HTH,
Barb Reinhardt
 
Let's say you have L in D1 and C in E1

=sumproduct(--($A$1:$A$7=D1),--($B$1:$B$7=E1))

HTH,
Barb Reinhardt







- Show quoted text -
Click to expand...

Nice! The SUMPRODUCT threw me off at first so I'm sure that's why I
never considered it. I'd been trying variations of COUNTIF, etc. The
only change was instead of taking up further cells such as D1,E1 I
used "L" and "C". Works like a champ and I appreciate your help.
 
Back
Top