Calculate average of values in a row

[Sakhile]

Hi Guys

I have transactional data that I am trying to analyze.

1. I am trying to get the average number of transactions that happened for each row. 

       - Basically in excel I would paste the table and then apply the Autosome average and drag down to get average for each row. The average would be in the last column.

2. Then I want a count of the Values that exceed the average for each row.

[IraWatt · Accepted solution]

Hey @Sakhile,

You can get the average number of transactions like this:

And count the number greater then average like this:

If you have any questions make sure to ask :)

HTH,

Ira

[grazitti_sapna · Accepted solution]

Hi @Sakhile , another way of solving this problem, please mark this post as a solution if it works!

[Sakhile]

Hi @IraWatt  and @grazitti_sapna 

Both your solutions have resolved my problem. Thank you both very much !!!!!!!!!!!!!!!!!!!

[IraWatt]

No worries @Sakhile! glad it worked for you :) also if @grazitti_sapna's solution worked for you your able to give both answers the solution tick :D

[Sakhile]

@grazitti_sapna  IraWatts solution was simpler and easier to understand and reperform hence why I accepted his.

[grazitti_sapna]

@IraWatt, I appreciate your recommendation. Thanks! 🙂

@Sakhile - No problem there are multiple ways of solving a problem, glad both worked for you!

Thanks!