Compare 2 columns and sum the larger value in column
Hello, I need help again. This is my formula: =SUM(IF(’01-24 DB’!$AK19:$AK156>’01-24 DB’!$AN19:$AN156,’01-24 DB’!$AK19,$AN20))
I would like to have a formula where I compare the value between AK and AN, and it picks the larger value and then it sums up the whole column.
Thank you.
Hello, I need help again. This is my formula: =SUM(IF(’01-24 DB’!$AK19:$AK156>’01-24 DB’!$AN19:$AN156,’01-24 DB’!$AK19,$AN20)) I would like to have a formula where I compare the value between AK and AN, and it picks the larger value and then it sums up the whole column. Thank you. Read More
