Formula needed.
Thanks Ron, keep the good work.
"Ron Coderre" wrote:
Using your example:
This formula returns the values associated with "Car":
B6: =SUMIF($A$1:$A$5,"Car",$B$1:$B$5)
Or...for more flexibility:
A6: Car
B6: =SUMIF($A$1:$A$5,A6,$B$1:$B$5)
Change range references to suit your situation.
Is that something you can work with?
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"FC" wrote in message
...
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.
|