I have a new problem now, which I'm struggling with so would appreciate some help.
Basically, I want to enter a function into cell C1 which will return the value in B1 (=SUM(B2:B6)) if it is more than the value in A1 (=SUM(A2:A6) ). However if the value in B1 is less than or equal to the value in A1 then I want the function to return the value in A1!
A
=SUM(A2:A6)
8
6
5
7
6
B
=SUM(B2:B6)
7
9
8
9
8
It seems easy when I write it down but I just can not work out the function! I was playing with SUMIF but wasn't having much luck.
Basically, I want to enter a function into cell C1 which will return the value in B1 (=SUM(B2:B6)) if it is more than the value in A1 (=SUM(A2:A6) ). However if the value in B1 is less than or equal to the value in A1 then I want the function to return the value in A1!
A
=SUM(A2:A6)
8
6
5
7
6
B
=SUM(B2:B6)
7
9
8
9
8
It seems easy when I write it down but I just can not work out the function! I was playing with SUMIF but wasn't having much luck.