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