• 409K Members
• 10.9K Online
• 466K Conversations
SOLVED

## exel average formula

Occasional Visitor

# exel average formula

HI. I need Your help. Have a great massive of data like this:

A   B     C      Expected result

1  a   4            -average (B1:B4)

2  a   4.1         -average (B1:B4)

3  a   3.5         -average (B1:B4)

4  a   2           -average (B1:B4)

5  b   1.1        -average (B5:B6)

6  b   1.7        -average (B5:B6)

7  c    1          -average (B7:B9)

8  c    5          -average (B7:B9)

9  c    2          -average (B7:B9)

...

Which formula do I need to create that will find the same value from "A" and return the average meaning from "B" whith the same "A" to the column "C"

Solution

# Re: exel average formula

That could be

`=AVERAGEIF(\$A\$1:\$A\$30,A1,\$B\$1:\$B\$30)`
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies