Thread
:
Formula needed.
View Single Post
#
10
Posted to microsoft.public.excel.misc
Westy
external usenet poster
Posts: 11
Formula needed.
i have the same question, would you be able to send me the working example
also. Please, many thanks. to
"Ron Rosenfeld" wrote:
On Thu, 27 Sep 2007 17:01:00 -0700, 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.
In addition to the SUMIF formula others have recommended, you might consider
using a Pivot Table (see the Data menu).
Using your data, I get this as a result:
Item Sum of Items
airp 22
boat 45
car 100
Grand Total 167
but it can be formatted in a variety of ways.
--ron
Reply With Quote
Westy
View Public Profile
Find all posts by Westy