You're welcome.

Pete

On Sep 28, 2:21 am, FC wrote:
THANKS A LOT.



"Pete_UK" wrote:
Here's one:

=100*SUMIF(A1:A5,"car",B1:B5)

You could put "car" into another cell, eg A6, then the formula could
become:

=100*SUMIF(A$1:A$5,A6,B$1:B$5)

I've made the row references absolute, so that you could put, say,
"boat" in A7 and copy the formula into B7 etc.

Hope this helps.

Pete

On Sep 28, 1:01 am, FC wrote:
A B
1 car 90
2 boat 20
3 airp 22
4 car 10
5 boat 25

I'm needing a formula that will add numbers in B related to the item in A .
Let's say a result for car = 100 ( 90+10) at the bottom on B6.
These are just 5 rows but I have around 150, however if you kindly provide me
with a formula for those 5, I can adjust it. THANKS in advance.- Hide quoted text -

- Show quoted text -