Hello,
I need to work out the totals for groups, of only some of which apply.

to explain.
Columns C,D,E,F,G,H and I contain values of carers that care for people
of a specific group. (entered as a numeric value)
Columns K to Z contains values of which ethnic group the carers belong
to. (Numeric values)

I need to work out the totals of the columns C to I (type of carer),
that's easy and done.

From those totals, I need to work out how many of which came from
columns L to Z (ethnic group), (column K is an excluded group from the
'of which' totals)

Hope I've explained clearly enough to understand.
Thanks.


--
AntiHero
------------------------------------------------------------------------
AntiHero's Profile: http://www.excelforum.com/member.php...o&userid=35768
View this thread: http://www.excelforum.com/showthread...hreadid=555401