CountIf question

S

Stuck

I'm having an issue adding additional criteria to my formula. Here is my
current formula:

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

Column A has number identifiers. Column P has a formula in it that
generates a letter. If the letter matches P3 then the cell is counted. I
would like to add Column C to my formula above. If Column C contains "x" and
column P matches P3, then count column A. Please keep in mind that P
contains a fomula, so text and numbers is not recognized....(I think)
 
T

T. Valko

If I understand what you want then create these named ranges:

Insert>Name>Define
Name: ColA
Refers to:

=OFFSET($A$9,,,COUNTA($A:$A)-2)

Name: ColC
Refers to:

=OFFSET($C$9,,,COUNTA($A:$A)-2)

Name: ColP
Refers to:

=OFFSET($P$9,,,COUNTA($A:$A)-2)

Then:

=SUMPRODUCT(--(ISNUMBER(ColA)),--(ColC="x"),--(ColP=P3))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top