Count using a Tally Chart based on a unique reference

Hi

 

I was wondering if any one could help me. I will try to explain it in writing in details.

 

So i have created a Tally chart on excel and i am trying to count the number of “1” that occurs based on a unqiue ID

I have a Individual per family coloumn and 6 extra coloumn to ensure if a person meet the criteria.

     

FamilyID  Individual per family coloumn Crime/ASB
1
Education
2
Child in Need
3
Employment
4
DV/DA
5
Health
6
Count of criteria per family level Count
1 1629     1       NEED A FORMULA 3
1 1629                
1 1629         1 1    
1 1629                
2 1630     1          
2 1630           1    
2 1630                
2 1630                
2 1630                
3 1631   1 1          
3 1631       1 1      
3 1631                
3 1631                
4 1632     1     1    
4 1632                
5 1633     1          
5 1633                
5 1633         1      
6 1634     1     1    
6 1634                
6 1634                
7 1635     1     1    
7 1635                
7 1635         1      
7 1635                
8 1636     1     1    
8 1636                
8 1636                
8 1636       1        

Is there any formula that i can populate.

 

Please help

 

Kind Regards,

Viral

 

By: Viral Patel

Leave a Reply

Your email address will not be published. Required fields are marked *