Combine all accounts that end in D

A

Ali

I have many accounts that end in the letter D such as
L4030D and 002D and other that do not. I want to combine
all the accounts that end in D. How do I do this?

Thanks,
Ali
 
O

otium

not sure what you mean by combine but....

assume the account cell is A1, the command =IF(RIGHT(A1,1)="D"......
should help you

Ala
 
B

Bernie Deitrick

Ali,

Use a helper column with a formula like

=Right(A1,1)

and use that as the filter (use D) or field source of your pivot table.

HTH,
Bernie
MS Excel MVP
 
K

kkknie

If you are adding up one column based on accounts that end in "D" you
can use:

=SUMPRODUCT(--(RIGHT(A1:A5,1)="D"),B1:B5)

Where column A has the account and column B is what you are adding.

K
 
D

David McRitchie

Or use the helper column for a Filtered list (instead of Pivot Table)
Select the helper column then Data, Filter, Auto Filter

Or And if you wanted to sort so that D accounts were separate
=IF(right(a1,1)="D","D,'')
 
D

Dave Peterson

Or even use the builtin "Ends with" option (under Custom) if staying with the
data|filter|autofilter.
 
Top