Hello all,

I hope someone can help me with this problem:

From a table, I want to summerize the value (column 2)
of all posts that has a specific text (column 1).

This text should be the same as in an unique cell.

Exemple:

Book 1
Record 2
Magazine 3
Book 4
Record 5
Book 6

Unique cell text: [book]

Number of books: [11]

What is the formula in the cell which shows the value 11?

If you know a solution, just copy the formula in your
reply (instead of trying to explain in writing, which
might be rather tiring). Hopefully, I can figure out
how to make it work.

(I have been using Excel for several years, for my
personal need.)

Thanks and Regards
Thomas Jedenfelt
Tyresö (Stockholm, Sweden)