Formula needed.
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.
|