Countif issue

  • Thread starter Thread starter Stuck
  • Start date Start date
S

Stuck

Here's what I have:

=COUNTIF(OFFSET($P$9,0,0,(COUNTA($A:$A))-2,1),$P3)

column A is a number
cell P9 is a formula that produces text "G"
cell P3 contains the text "G"
Column C has multiple text strings "John Doe" "Jane Doe"

Here's what I need:

In addition to the formula above, I would like filter column C for a
specific name, thus giving me the total number of "G" items per "John Doe."

Any assistance would be appreciated. Thank you.
 
=sumproduct(($P$9:$P$100="G")*($C$9:$C$100="John Doe"))

Adjust your range to suit
 
Back
Top