You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"richzip" wrote in message
...
Thank you! That worked perfectly. If the totals are the same, I will
use
the values from column C, and it looks like this formula does that.

Thanks again!

"T. Valko" wrote:

In the meantime, this will do what you want:

=IF(SUMIF(A:A,A2,B:B)SUMIF(A:A,A2,C:C),B2,C2)

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
I'm following you on this, but, what should happen if the totals are
equal?

1...1...2
1...2...1
1...1...1

Both totals are 4

--
Biff
Microsoft Excel MVP


"richzip" wrote in message
...
I have a very large spreadhseet. The spreadsheet looks similar to the
one
below. I want to compare the totals (by employee) in column B with
the
totals (by employee) in column C. If the total in column B is larger,
then I
want to transfer those values to column D. If the total in column C
is
larger, then I want to transfer THOSE values to column D.

As you can see, for ID 1 ..the total of column C is greater, so those
values
are carried over to column D. For ID 2 ..the total of column B is
greater,
so those values are carried over.

Since there are a large number of employees, how do I set up a formula
to
compare these values by employee and make the transfer? Thanks!

A B C D
1 ID Sked Act Greater
2 1 5 6 6
3 1 7 5 5
4 1 2 4 4
5 2 3 4 3
6 2 10 2 10
7 2 5 4 5
8 2 6 9 6