Sorting Merged Sum Fields

M

Mike T.

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!
 
F

Frank Kabel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If 0 then blank 9
VBA? 3
VBA? 1
Value of minutes not calculated 11
Counting formula 1
Translating Formulas to Functions 0
Using SUM(INDIRECT()) 2
Excel formula for inventory problem 3

Top