You need to swap my a's to b's
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
Try this. Will not sum if col a is blank or has a number

=SUMPRODUCT(((ISTEXT(A2:A22)*(LEN(TRIM(A2:A22))0) *B2:B22)))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"berniewind" wrote in message
...
Here is what I want to do. I have numbers in column A and I have text
and
blanks in column B. I want to know the sum of the numbers in column A
that
have text in coumn B.