sum

D

Danne

Hey!

Is there a way to not include subgroups in excel. For
example I want to sum up with =sum(p100:p105) but p102 and
p103 is subgroups that shouldn't be counted... any ideas?

Regards,
Daniel
 
B

Bob Phillips

Daniel,

You can simply do
=SUM(P100:p101,P104:p105) or
=SUM(P100:p105)-SUM(P102:p103)
but that relies on you knowing where subgroups lie. If there is data that
identifies them, you could use SUMIF to identify and subtract.
 

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

Cumulative formula for word table 0
Protect Excel 2007 but allow ungrouping 0
Sum of sub groups 3
Sharing Excel 365 Mac<->PC 0
Getting the formula right 5
Hide/Show details in an Outline Group 0
Pivot table question: Sorting the subgroup in a pivot table (whenusing the top 10 option for the sub 0
How to Update SUM formula after inserting rows 2

Top