sum

[Danne]

Hey!

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

Regards,
Daniel

 

[Bob Phillips]

Daniel,

You can simply do
=SUM(P100101,P104105) or
=SUM(P100105)-SUM(P102103)
but that relies on you knowing where subgroups lie. If there is data that
identifies them, you could use SUMIF to identify and subtract.