Subtotal: Sum & Count

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• Sep 19, 2003

• #2

See the Data | Subtotals... menu command.

 

Upvote 0

P

Parra

Well-known Member

Joined

Feb 21, 2002

Messages

752

• Sep 19, 2003

• #3

I know how to use the subtotal, but how do I SUM and COUNT at the same time. Is it possible.

Thanks

 

Upvote 0

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• Sep 19, 2003

• #4

Not "at the same time". I'd use the Subtotal... command to create sums and then change the 1st argument of the resultant SUBTOTAL function from 9 to 2 as needed.

Perhaps, a PivotTable may work as well.

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Sep 19, 2003

• #5

Do it first with SUM on the first column. Then do it again with COUNT on the second column, making sure Replace current subtotals is unchecked.

Or do both columns with SUM and change the first argument for the SUBTOTAL function from 9 to 3 for the column you want to count. You can use Edit|Replace for this.

 

Upvote 0

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• Sep 19, 2003

• #6

Andrew Poulsom said:

Do it first with SUM on the first column. Then do it again with COUNT on the second column, making sure Replace current subtotals is unchecked.

Click to expand...

Andrew, the problem with this approach is the an additional row is inserted into the list.

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Sep 19, 2003

• #7

Mark W. said:

Andrew Poulsom said:

Do it first with SUM on the first column. Then do it again with COUNT on the second column, making sure Replace current subtotals is unchecked.

Click to expand...

Andrew, the problem with this approach is the an additional row is inserted into the list.

Click to expand...

That's why i said "Or ..."

 

Upvote 0

P

Parra

Well-known Member

Joined

Feb 21, 2002

Messages

752

• Sep 19, 2003

• #8

I have to go to a meeting, I'll work on it when I return.

I appreciate your responses.

 

Upvote 0