decentlydoped
New Member
- Joined
- Dec 19, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I want to use a formula which can detect the values for the whole column(which gets updated everyday), if that value is true then it will average the values of all those respective other columns having the value. for example: for the whole column C, every cell having value 2 its respective values in column M will get averaged.
Column C having values 1 to 6.
Every number from 1 to 6 in column C has respective data in column M for the month. The sheet gets updated everyday. So, I wish to average the data in column M for all the respective values in column C and should get updated everyday by its own.
Column C having values 1 to 6.
Every number from 1 to 6 in column C has respective data in column M for the month. The sheet gets updated everyday. So, I wish to average the data in column M for all the respective values in column C and should get updated everyday by its own.