Itemised list entries

[Orangeanorak]

Can you please tell me the formula to total different items individually from a column of mixed entries.

i.e. Cell V4 equals the sum of all entries of CARS in column W where there are entries of Cars, buses and taxis listed

Many thanks for your time and assistance.
Regards
Jn
:D

 

[Egress1]

Can you please tell me the formula to total different items individually from a column of mixed entries.

i.e. Cell V4 equals the sum of all entries of CARS in column W where there are entries of Cars, buses and taxis listed

Many thanks for your time and assistance.
Regards
Jn
:D

In Cell V4 place =COUNTIF(W:W,"CARS")

 

[Josue Barocio]

If I inderstand your request correctly, you can use the COUNTIF function. Assuming you have a mixed collection of cars, taxis and buses, in cells W1 through W100, then the formula =COUNTIF(w1:W100,"cars") in V1 will display the number of cells with the word "cars" in W1:W100.

Joe Barocio

 

[Orangeanorak]

Solved - thanks :P