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


"Stuck" wrote:

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.

So simple!

Thank you.

"Teethless mama" wrote:

=sumproduct(($P$9:$P$100="G")*($C$9:$C$100="John Doe"))

Adjust your range to suit


"Stuck" wrote:

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.

If there are no matches, how do I get it to return a zero instead of blank?

"Stuck" wrote:

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.