Get average of a column if another column is checked?

Sean Huynh

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!

Jon Baier

Try this:

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

Jon Baier

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

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?

Sean Huynh

@Jon Baier yes, that is correct. Thanks!

Jon Baier

Try this:

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

Jon Baier

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. :-)

Sean Huynh

@Jon Baier works perfectly, thank you so much! You are a lifesaver.