Formula needed.
=SUMIF(A1:A5,"car",B1:B5)
"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.
|