Thread
:
Help with Formula
View Single Post
#
6
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Help with Formula
=SUMPRODUCT(((ISTEXT(b2:b22)*(LEN(TRIM(b2:b22))0) *a2:a22)))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"berniewind" wrote in message
...
Column A has number in the cells and column B has text in some of the
cells.
I want to sum the number in Column A if they have text in Column B on the
same row.
"Don Guillett" wrote:
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett