D
Dhazmo
Hi,
Column A contains text and numbers with some recurring text ie
1234 xxx 098
1342 xxx 878
5642 xxx 456
Column B contains a number.
I need to sum column b on selected text criteria in Column A. I can't use
LEN or RIGHT as the number of characters in column A are never the same and
there isn't always a space between numbers and text. I thought trying to use
a SUMPRODUCT with a FIND as one of the array options, but for the life of me
can't make it work.
Help please
Column A contains text and numbers with some recurring text ie
1234 xxx 098
1342 xxx 878
5642 xxx 456
Column B contains a number.
I need to sum column b on selected text criteria in Column A. I can't use
LEN or RIGHT as the number of characters in column A are never the same and
there isn't always a space between numbers and text. I thought trying to use
a SUMPRODUCT with a FIND as one of the array options, but for the life of me
can't make it work.
Help please