Google Answers Logo
View Question
Q: excel formula ( No Answer,   1 Comment )
Subject: excel formula
Category: Computers > Algorithms
Asked by: jalm1-ga
List Price: $5.00
Posted: 23 Nov 2006 13:26 PST
Expires: 23 Dec 2006 13:26 PST
Question ID: 785124
I am looking for an excel formula that will allow me run a formula on
select rows in a table. Here is the scenario, the table has a series
of identification columns and when an item in a row corresponds to one
of the identification columns there is a ?1? in the cell. Ie;

ID	Cost	Rate	A	B	C	D	E	
1	10	5%	1
2	10	7%		1
3	10	8%			1
4	10	9%				1
5	10	10%					1

Obviously its not that clean, but what I need is part of the formula
that select all the rows that have a 1 in A, or B and so on. End goal
is to run formulas that  would sum all costs for A items or B items,
give a weighted average of rates for all A items and so on. I just
cant figure out how to pull out only the A rows.
There is no answer at this time.

Subject: Re: excel formula
From: ansel001-ga on 23 Nov 2006 21:31 PST
Use the sumif function.  If cost is column B and "A" is column D:


sumif contains 3 arguments, the range, criteria, and sum range.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy