Advertisement

03.15.2008 at 03:23PM PDT, ID: 23244533
[x]
Attachment Details

calculate a sum or a mean of values in column B for all lines where column A is a given string

Asked by weissenb in Microsoft Excel Spreadsheet Software

Tags: , ,

Hi everybody,

I would like to calculate a sum or a mean of all values in column B for all lines of B  where column A is a given string.. directly, not using a macro or VBA.
Another way to use index?

Thanks for any advice

JacquesStart Free Trial
 
Keywords: calculate a sum or a mean of values in …
Title
1 macro sum
2 how to sum elapsed times
3 Time calculation
4 Sum in a query
5 Calculating Commission Based on Cust…
6 Turning sums into fixed numbers after …
 
Loading Advertisement...
 
[+][-]03.15.2008 at 03:46PM PDT, ID: 21134643

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.15.2008 at 04:28PM PDT, ID: 21134784

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.15.2008 at 04:30PM PDT, ID: 21134790

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Excel Spreadsheet Software
Tags: microsoft, excel, 2003
Sign Up Now!
Solution Provided By: byundt
Participating Experts: 2
Solution Grade: A
 
 
[+][-]03.15.2008 at 04:32PM PDT, ID: 21134796

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.15.2008 at 04:33PM PDT, ID: 21134798

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628