get max value using checkbox selections

Question

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 the sum to work using:

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

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

score 0 · Answer 1 · answered Nov 19 '19 at 19:03

0

try MAXIFS

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

answered Nov 19 '19 at 19:03

player0

124,011
12
67
124

score 0 · Answer 2 · answered Nov 19 '19 at 19:11

0

or you can FILTER it:

=MAX(FILTER(B3:B7, C3:C7=TRUE))

answered Nov 19 '19 at 19:11

player0

124,011
12
67
124

get max value using checkbox selections

2 Answers2