SUM of n AVERAGES

[XcelLearner]

Hi,

I have an array of n rows in Column A and B. I need to sum all the averages of A2:B2 to An:Bn. How could I do it? Thanks a lot.

 

[Joe4]

Won't this get you what you need?

=SUM(A:B)/2

 

[XcelLearner]

Won't this get you what you need?

=SUM(A:B)/2

Thanks for your help. Well, I guess I need to revise the problem then. Will be back.

 

[XcelLearner]

I think SUM()/2 is a very neat solution to my previous problem - I must have been overthinking. I have a modified problem then.

Suppose I have an array of n rows with two values (indicators 1 and 2) for each of n tickers from AA to ZZ. I need to calculate sum(average()) of the tickers AA, AC, and AD in List 1. How can I do that? (SUM()/2 is fine if it gives the result needed.)

Thanks a lot.

 

[Joe4]

I need to sum all the averages of A2:B2 to An:Bn.

I need to calculate sum(average()) of the tickers AA, AC, and AD in List 1.

OK, you seem to have changed the question entirely, where ou have gone from ALL to some subset of them.
But your formula:

=SUM(AVERAGE(B2:C2,B4:C4,B5:C5))

seems to do just that.

So what is the issue with it?

 

[XcelLearner]

OK, you seem to have changed the question entirely, where ou have gone from ALL to some subset of them.
But your formula:

=SUM(AVERAGE(B2:C2,B4:C4,B5:C5))

seems to do just that.

So what is the issue with it?

Sorry, I didn't make myself clear again (What was wrong with me today?).

I need a formula that looks into List 1 for the constituents and finds their respective values stored in A:C to return results. Assuming that the constituents of List 1 change every now and then, and I can't manually revise the formula to do so. Is there a way to do it?

 

[Joe4]

Sorry, I didn't make myself clear again (What was wrong with me today?).

I need a formula that looks into List 1 for the constituents and finds their respective values stored in A:C to return results. Assuming that the constituents of List 1 change every now and then, and I can't manually revise the formula to do so. Is there a way to do it?

OK, that is an entirely different question than your original question (and one that I do not personally have an answer for you).
So you should post theis new question it to its own thread.

 

[XcelLearner]

OK, that is an entirely different question than your original question (and one that I do not personally have an answer for you).
So you should post theis new question it to its own thread.

Thank you very much for your suggestion. Have a nice day.