You may use SUMPRODUCT with the checkings you want to do. This is an
example, to find careers in column C equal to "A" and ethnic groups in column
M equal to 1:
=SUMPRODUCT(--(C1:C10="A"),--(M1:M10=1))
You can use references instead of hard coded values, it can be tailored to
fit your needs.

Hope this helps,
Miguel.

"AntiHero" wrote:


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