mardi 19 novembre 2019

Google Sheets - get max value using checkbox selections

I am trying to implement a function in google sheets that will provide the max value from a set of values in column B based on the corresponding checkbox in column C.

I was able to get teh sum to work using:

=sumif(C3:C7, TRUE, B3:B7)

However, I am not having any luck finding the max value of the set.




Aucun commentaire:

Enregistrer un commentaire