Hi

not following you very well

if in your summary, you have in col A the following
A B
Car
Bus
Cycle

a simple vlookup such as the below formula will do

=VLOOKUP(A8,$A$1:$B$6,2,0)

otherwise, pls elaborate
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Narnimar" wrote:

I got a list in B:B in which there are values in but some are blank. I need a
if formaula can summerize it in A column with only those which are
nonblanks.
A B
Car 2
Bus 1
Train blank
Flight blank
Cycle 20
Horse Blank

the sumery should apear just like -
A B
Car 2
Bus 1
Cycle 20

Any Help is highly appreciated.