Sorting Merged Sum Fields
 

Hi,

I'm trying to write a worksheet for a doubles tournament. Here's an example
of what I have (rows 1 and 2 are headers)

A3, A4 are merged and locked (what place each team is in)
B3 and C3 is the name and city of player #1.
D3:F3 are the scores of the three games for player #1.
G3 is the sum of D3:F3 (subtotal player #1)
H3 contains optional bonus points.
I3 is the grand total for player #1 (SUM(G3:H3)).

B4 and C4 is the name and city of player #2.
D4:F4 are the scores of the three games for player #2.
4G is the sum of D4:F4 (subtotal player #2)
H4 contains optional bonus points.
I4 is the grand total for player #2 (SUM(G4:H4)).

J3 and J4 are merged and contain the team total (SUM(I3:I4)).

I'm trying to sort on the team total (column J) (descending), but I always
get an error saying "This operation requires the merged cells to be
identically sized." I obviously need to keep all of the pair's information
as one cohesive unit (from B3 to 4J).

If it were for myself, I'd set up something on a database, but it'll be
going to someone else, who doesn't have all the firepower I have.

I've done some googling, but this is still clear a mud to me. Does anyone
have an idea on this one? If anyone wants me to mail them the sheet to see
what I mean, let me know.

Thanks!
--
Mike T
Spiffy sig currently under development.

Hi
don't thinks this is possible. Don't use merged cells is the only solution
for this. you have to use one single row for each record

--
Regards
Frank Kabel
Frankfurt, Germany
"Mike T." schrieb im Newsbeitrag
...
Hi,

I'm trying to write a worksheet for a doubles tournament. Here's an
example
of what I have (rows 1 and 2 are headers)

A3, A4 are merged and locked (what place each team is in)
B3 and C3 is the name and city of player #1.
D3:F3 are the scores of the three games for player #1.
G3 is the sum of D3:F3 (subtotal player #1)
H3 contains optional bonus points.
I3 is the grand total for player #1 (SUM(G3:H3)).

B4 and C4 is the name and city of player #2.
D4:F4 are the scores of the three games for player #2.
4G is the sum of D4:F4 (subtotal player #2)
H4 contains optional bonus points.
I4 is the grand total for player #2 (SUM(G4:H4)).

J3 and J4 are merged and contain the team total (SUM(I3:I4)).

I'm trying to sort on the team total (column J) (descending), but I always
get an error saying "This operation requires the merged cells to be
identically sized." I obviously need to keep all of the pair's information
as one cohesive unit (from B3 to 4J).

If it were for myself, I'd set up something on a database, but it'll be
going to someone else, who doesn't have all the firepower I have.

I've done some googling, but this is still clear a mud to me. Does anyone
have an idea on this one? If anyone wants me to mail them the sheet to see
what I mean, let me know.

Thanks!
--
Mike T
Spiffy sig currently under development.