how to combine multiple results in one cell

[Tet Htut Naing]

Dear All,

I have little knowledge in excel, but it made some attempts in summing up all the results in cells into one cells. To be clearer, I have column of writing gender of the people in F and M. Again, the regions of the people are different and they are separated with a row, for example 7 regions. After each region, I have this formula to count F and M of one region

=(H1&"="&COUNTIF(H5:H85,"F"))&" "&"/"&" "&(H2&"="&COUNTIF(H5:H85,"M"))

.

It gives me the result of F and M numbers of one region in one cell, for example, F = 20 / M = 17.

After all, I want all the result to be summed up in one cell again. Can you please help me out?

Thanks advance
KO Htut

 

[FormR]

Hi, can't you just increase the COUNTIF() ranges so they cover all the regions - for example.

=(H1&"="&COUNTIF(H5:H1000,"F"))&" "&"/"&" "&(H2&"="&COUNTIF(H5:H1000,"M"))

 

[Tet Htut Naing]

Deeply thank for your reply and suggestions.

But I want the results of each of regions separately and finally, I want them sum up. That makes me difficult.

Best Regards,
Ko Htut

 

[Tet Htut Naing]

Yes, You are right.

I will do with my formula for separate results and use your formula for overall results. Brilliant!!

Thanks,
Ko Htut

 

[FormR]

I will do with my formula for separate results and use your formula for overall results.

Yes - exactly