## Is anyone having problems with nested subtotaling in XP Excel

MS EXCEL

### Next

• 1. Cell Reference Question
Hi try =ADDRESS(ROW(),COLUMN()) or =ADDRESS(ROW(),COLUMN(),4) Fred wrote: > With my cell pointer in row 100 & column C, the column( ) function is > returning "3". > 1. How do I get it to return "C", and > > 2. What formula can I use to return "C100"? > > Thanks, > Fred
• 2. Unnaming cells already named
I was wondering if someone knows how to "unname" (or delete the name) a range of cells I gave a name (1st mistake) and then saved it ( 2nd mistake). Thanks for helping. -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing.
• 3. Sumproduct problem.
Hi, I have the following formula: =SUMPRODUCT(--(\$A\$10:\$A\$5000>=Sheet2!\$P\$3),--(\$A\$10:\$A\$5000<=Sheet2!\$R\$3),--(\$B\$10:\$B\$5000=N3),--(\$E\$10:\$E\$5000<TIME(41,40,0)),\$D\$10:\$D\$5000) What its suppose to do is to filters a criteria (col B) between two dates (col A), it then totals all the hours for that month under 41 hours and 40 minutes. I have a running total for that month on column E. Sheet2!\$P\$3 and Sheet2!\$R\$3 are the two dates. I get a figure but not the correct one. Can anybody help? -- capt

### Is anyone having problems with nested subtotaling in XP Excel

```Since being put onto Windows XP I've had disappointing/useless results from
my subtotalling routines. Typically I will nest subtotals and this is where
I'm getting inconsistencies.

Data is out of line, "Grand total" are empty .. just ugly

What could be the problem?
```

### RE: Is anyone having problems with nested subtotaling in XP Excel

```I haven't had a problem with SUBTOTAL using Excel XP.  what formula are you
using?
--
Brevity is the soul of wit.

```

### Re: Is anyone having problems with nested subtotaling in XP Excel

```Apparently, it's a known problem that should be corrected by installing this
hotfix:

http://www.**--****.com/

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

from
where

```

### Re: Is anyone having problems with nested subtotaling in XP Excel

```Sorry, wrong one I think

http://www.**--****.com/
Multilevel subtotals are in the wrong position in Excel 2002 and in Excel
2003

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

this

```

```it all works except for H6>=6,I6>=6,J6>=6,K6>=6,L6>=6 in each if
statement.  Sometimes these cells are blank; therefore, there is no
calculation, but it must calculate if a number >=6 is in this cell

=IF(AND(M6>29.9,F6<19),32*5,IF(AND(M6>29.9,F6>=19),
30*5,IF(AND(M6<30,F6<19,H6>=6,I6>=6,J6>=6,K6>=6,L6>=6),
39*S6,IF(AND(M6<30,F6<19,H6>=6,I6>=6,J6>=6,K6>=6),
39*S6,IF(AND(M6<30,H6<6,I6<6,J6<6,K6<6),26*S6,0)))))

Can anyone help me figure this out.  Thank you so much in advance!

```

```I have sorted my spreadsheet in the order of levels - outer subtotal as
primary sort, next level as secondary sort.  Then I have created subtotals
for the outer (primary) group.  Once complete I have nested the subtotal for
the secondary item.  The subtotal for the second level is appearing (on
occasion) below the primary subtotal instead of above.
```

```I some but not all spreadsheets, my nested subtotal (slsperson) is placed
below the primary subtotal (branch). It has only happened to me since

I sort by Branch, slsperson, customer. Then Primary subtotal is branch
(checks on replace current subtotals and summary below) and all is fine. Then
when I do subtotal on Slsperson it will place (above items unchecked) the
slsperson subtotal BELOW the branch. And also the levels (1,2,3) are not
displaying properly.

Does anyone have a suggestion for me?
```

```When I nest a subtotal in Excel XP or 2003, some of the secondary subtotals
appear below the primary ones. When I summarize up one level, the detail for
these secondary subtoals still show.

This is an example of how it should look:

primary detail     secondary detail
primary detail     secondary detail
SECONDARY SUBTOTAL
PRIMARY SUBTOTAL

This is how some of mine display:

primary detail     secondary detail
primary detail     secondary detail
PRIMARY SUBTOTAL
SECONDARY SUBTOTAL

And, when I summarize at the Secondary Sutotal level, the Detail stil shows.

Has anyone else experianced this problem? If so, how did you fix it?
```