Emperor在吗？大家请帮忙。。。求Excel公式。。。

[The Devil Wears Prada]

Calculate the average values for A and B. MS Excel

item number
A 2
B 2
A 4
A 3
B 6

Average A ??
Average B ??

 

[11.11.11]

应该不难吧，不过我不会。
我闪。

 

[mooncake]

=AVERAGEIFS(B1:B5, A1:A5, "A")
=AVERAGEIFS(B1:B5, A1:A5, "B")

 

[The Devil Wears Prada]

=AVERAGEIFS(B1:B5, A1:A5, "A")
=AVERAGEIFS(B1:B5, A1:A5, "B")

Tried...did not work...

 

[马尔泰·若曦]

=AVERAGE(B1,B3,B4)

=AVERAGE(B2,B5)

 

[The Devil Wears Prada]

=AVERAGE(B1,B3,B4)

=AVERAGE(B2,B5)

We are talking about a large Excel spreadsheet...thanks anyway...you are so cute...

 

[ForwardRetreat]

TRY

 

[The Devil Wears Prada]

TRY

Did not work...just searched the function in Excel...does not have Averageif...

 

[ForwardRetreat]

TRY THIS THEN. IF NOT, YOU HAVE TO ASK GOD.

 

[The Devil Wears Prada]

TRY THIS THEN. IF NOT, YOU HAVE TO ASK GOD.

Great thanks!!!...it works now...

 

[9981]

I will suggest you use pivot table, Insert - Pivot table and select the data range, you can do sum, average and a lot of other aggregation functions.

 

[The Devil Wears Prada]

I will suggest you use pivot table, Insert - Pivot table and select the data range, you can do sum, average and a lot of other aggregation functions.

Took course on that...it sucked my brain out...too hard to maneuver...:blowzy:

 

[iDolly]

If you don't have AVERAGEIF function, you should probably update to a more recent version of Excel.

 

[The Devil Wears Prada]

If you don't have AVERAGEIF function, you should probably update to a more recent version of Excel.

It's IT's call then...I wouldn't bother...

 

[Shirley72]

3 steps to get it