Countif and multiple columns to validate
Did you test your formula?
"AKphidelt" wrote:
=SUM(IF(AND(MATCH(T1,NameField1,0),MATCH(T1,NameFi eld2,0)),1,0))
See if this works... Im thinking that you are matching names so summing the
value 1 is just like counting. This formula if you put the right references
in it should count only the values that match both requirements. LMK if you
have any other questions.
"ouch" wrote:
ok in column T I have a value that needs to be counted if it matches a name.
However it also needs to match a name in column P.
Anyideas on how I could accomplish this?
thanks in advance.
|