Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to calculate an AVG of numbers in a column "A" where only including records containing value "X" in the column B

Topic Labels: Formulas
Solved
Jump to Solution
1389 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Ziga_Krampersek
4 - Data Explorer
4 - Data Explorer

Could somebody help with a formula? Thanks in advance :slightly_smiling_face:

1 Solution

Accepted Solutions
Robin_Travis
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Ziga

I think you should be able to do this by using groups. If you group by column B and then set the column A to average. You will get an average for each group. If you just want to see the group averages, collapse their contents and you will have a summary row for each group. One thing to note, if you have any empty entries in the group, it will distort the average. e.g. say one group has 5 items + an extra blank row - the average will be divided by 6 rather than 5. Hope this helps

See Solution in Thread

2 Replies 2
Robin_Travis
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Ziga

I think you should be able to do this by using groups. If you group by column B and then set the column A to average. You will get an average for each group. If you just want to see the group averages, collapse their contents and you will have a summary row for each group. One thing to note, if you have any empty entries in the group, it will distort the average. e.g. say one group has 5 items + an extra blank row - the average will be divided by 6 rather than 5. Hope this helps

Thank you! Will give it a shot