Get average of a column if another column is checked?
Hi everyone!
I was hoping to get assistance on writing a formula.
I was wondering if there's a way to get the average of numbers "RWA Accepted to NTP Actual" if "FY20 RWA" column is checked? Thank you!
Best Answers

Try this:
=AVG(COLLECT([RWA Accepted to NTP Actual]:[RWA Accepted to NTP Actual], [FY20 RWA]:[FY20RWA], 1))

Make sure the spaces in your column names are right in the formula. Looks like I forgot a space in the [FY20 RWA]:[FY20 RWA] part. :)
Answers

Are you trying to average the RWA Accepted to NTP Actual column? So if any row has the FY20 checkbox checked, then include it in the Average for the column?

@Jon Baier yes, that is correct. Thanks!

Try this:
=AVG(COLLECT([RWA Accepted to NTP Actual]:[RWA Accepted to NTP Actual], [FY20 RWA]:[FY20RWA], 1))

Make sure the spaces in your column names are right in the formula. Looks like I forgot a space in the [FY20 RWA]:[FY20 RWA] part. :)

@Jon Baier works perfectly, thank you so much! You are a lifesaver.
Help Article Resources
Categories
Check out the Formula Handbook template!