excel function help (again!)

Associate
Joined
5 Apr 2004
Posts
495
Location
London
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.
 
humm I think maybe I should be using the IF function. If I figure it out I'll post the result, but would appreciate help also.
 
Back
Top Bottom