If statement

[BUSJEDWA]

I need data in one cell in sheet 1 to pick up data from sheet 2, either in column A or column B, depending which is greater. Therefore i need an if statement to pick up the higher value - any helpers? Many thanks.

[NBVC]

=Max(Sheet2!A1,Sheet2!B1) will take max of A1 or B1 from Sheet2

[BUSJEDWA]

Ok, but what I’m doing is summing up a match on cell U59 in sheet 1 with column C in sheet 2, this then totals the figures in column I, the formulae is as follows:


=SUMIF('Sheet2'!C:C,Sheet1!U59,'Sheet2'!I:I)



But what I need to do is pick up the total of column I, or column J, depending on which is greater … so, how do I get you max formulae to work with my original?

[NBVC]

Do you mean?

Please Login or Register  to view this content.

or are you looking for the max of each I or J and then sum those up?

Edit:

If you mean the ladder... then

Please Login or Register  to view this content.

which must be confirmed with CTRL+SHIFT+ENTER keys not just ENTER.. you will see { } brackets around the formula.

Note: You cannot use whole column references with the last formula unless you have XL2007. Adjust ranges to suit

[BUSJEDWA]

yes, i'm looking for the max of column I against the max of column J, and use the highest total. Thanks for you help!

[NBVC]

yes, i'm looking for the max of column I against the max of column J, and use the highest total. Thanks for you help!

Still ain't 100% sure which you're after. ... but if noticed I edited my last post to include another option... one of those 2 formulas should do the trick....