Countif issue
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.
|