1

Is it possible to sum the biggest values of each row? This will be more clear: https://docs.google.com/spreadsheets/d/13ah97AwIhZt1RcxS2FMkEmKfwIKbnhMQsXyESzesSI4/edit?usp=sharing

The goal is to move actions from MAX(C1; C2) and SUM(MAX) to one query;

Alcadur
  • 681
  • 1
  • 8
  • 22

1 Answers1

2

impossible, or is it...

if you got only two columns as in your example you can do:

=SUMPRODUCT(IF(C7:C>D7:D; C7:C; D7:D))

enter image description here

for multiple columns you can find the formula here:

https://stackoverflow.com/a/65435321/5632629

(just change avg for max)

player0
  • 124,011
  • 12
  • 67
  • 124