formulae

  • Thread starter Thread starter gerryR
  • Start date Start date
G

gerryR

Sorry if this is a simple question (I used to know excel alot better ... I
think!)

I have a column with about various text strings in each cell. In a single
cell to the right of this column I want to get the sum of a particular word
from that column.

can anyone help ?
thanking you
gerryR
 
Sorry, say my column contains

NT
2000
2000
NT
XP
XP

then in my cell to the right I want to be able to display

NT= 2
so it counts the amount of times NT appears in the column.
thanks
gerryR
 
Another..........can be copied down.........

=A1&"= "&COUNTIF(A:A,A1)

Vaya con Dios,
Chuck, CABGx3
 
Back
Top