=SUMPRODUCT(--(RIGHT(A1:A4,1)="a"))

Mangesh


"neil" wrote in message
...
Thanks, works like a charm.

Can this be modified to count how many instances of the text value
appears?
For instance, a countif based on "a"?

Regards

"Mangesh Yadav" wrote:

Suppose the column in question is A, then use the following formula:
=SUMPRODUCT(--(RIGHT(A1:A4,1)="a"),INT(LEFT(A1:A4,2)))

I have assumed:
A1 = 22a
A2 = 23b
A3 = 24a
A4 = 25c

Teh above formula returns 46 for t = a

Mangesh


"neil" wrote in message
...
Hi,

I have several columns of data in the format "nnt" where n= numeric
value,
t=text.

I need to sum up the numeric values, based on the text value.

Is there any way I can do this?

Thanks for the help.