Forum Discussion

KelseyErwinMusic's avatar
KelseyErwinMusic
Copper Contributor
Dec 19, 2025

Find average with checkboxes

Hello,  I’m not fluent in Excel but I do alright. Currently I am having a real hard time figuring this out. I’m trying to pull averages from different cells to one cell but based on if a box is chec...
excel
Olufemi7's avatar
Olufemi7
Iron Contributor
Dec 23, 2025

Hello KelseyErwinMusic​, 

If your checkboxes are linked to cells that return TRUE/FALSE, you can average only the selected values with this formula:

=IF(COUNTIF({D10,H10},TRUE)=0,
   "",
   SUMPRODUCT({C11,G11}*--{D10,H10}) / SUMPRODUCT(--{D10,H10})
)

 

  • Works by multiplying each value with its checkbox (TRUE = 1, FALSE = 0).
  • Divides the sum of checked values by the number of checked boxes.
  • Returns blank if no boxes are checked.

Extend the arrays {C11,G11} and {D10,H10} for more people, or use a column setup for a simpler formula:

=IF(COUNTIF(H10:H20,TRUE)=0,
   "",
   SUMPRODUCT(C11:C21*--H10:H20) / SUMPRODUCT(--H10:H20)
)