Re: Need to total how many came from a particular group.

Thanks for replying Miguel Zapico, However this hasn't solved my query. I've tried changinhg the formular slightly, but to be honest, I'm not entirely sure what I was changing was right. In all cases, this hasn't given me the result I was looking for.

I think it was to do with my explanation of the problem I was trying to solve.

I'll try to explain completely.
I need to collect totals of particular types of carers, and then work out, out of how many in each group, came from ethnic groups.

So Carers info is (Column C to I respectively), Data is interted into the rows, for 1 carers information (there can be 2 peoples data in the same row, if they come from the same family i.e. Father and Son), they can belong to more than 1 type of carer group but not all of them. So could have a value of 1(carer) in column C and E.

In column T to AH, are the Ethnic group codes, of which a carer can only belong to one group.

I need to get the total of carers in column C, and work out how many of them came from the total of columns T to AH. This total is not how many came from column T or W etc, but from the range of columns T to AH.
Then get the total for column D, then E and so on.

Again, I hope I've explained well enough.

Thanks
Anti

-- 
AntiHero
------------------------------------------------------------------------
AntiHero's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35768
View this thread: http://www.excelforum.com/showthread.php?threadid=555401