countif column d equals x and column a noblank

[Willie Wilson]

total of a column where the text is "X" and the name column is not blank.

 

[Tyro]

For which version of Excel?

 

[T. Valko]

Try this:

=SUMPRODUCT(--(A1:A10<>""),--(D110="x"))

 

[Don Guillett]

=SUMPRODUCT(--(LEN(TRIM(a2:a23))>0),--(d2:d23="x"))

 

[Willie Wilson]

2003 excel

For which version of Excel?