Formula that averages a column

Bridget Sloane

HI Smartsheet community,

I need a formula that averages one column (# of jobs) if a checkbox is checked.  I think I need to use AVERAGEIF and ISBOOLEAN, but I can't get the syntax right.  Help!

-Bridget Sloane

L_123

=averageif(CheckboxColumn:CheckboxColumn,True, [# of jobs]:[# of jobs])

Bridget Sloane

That works perfectly - thanks so much!

 

L_123

Not a problem.