lheunis
New member
- Joined
- Mar 27, 2018
- Messages
- 13
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
hi, not sure if this is even possible
i have a spreadsheet of about 31 users, these users are split into categories based on the total of Y and N indicators, basically at the end of the day they are either "big", "Medium" or "small"
what i need is a way to take my total numbers of accounts and split them into the 3 categories above (big, small medium) this cannot be split equally
i want to use the countif function to see how many "bigs" there are for example and then allocate the accounts to them
let’s say i have 4 big, 19 Medium and 8 Small users and my total accounts is 41427, i need the 41427 split between them using the numbers above
i will attach my spreadsheet, i want to be able to just change the total (in yellow) and the formula to run through and change results of how to split population (in green) - this should also at bottom again total to 41427
you will see my formulas and used and hopefully understand what i tried to do, i am stuck
i used the following to identify the split in columns H - K
i have a spreadsheet of about 31 users, these users are split into categories based on the total of Y and N indicators, basically at the end of the day they are either "big", "Medium" or "small"
what i need is a way to take my total numbers of accounts and split them into the 3 categories above (big, small medium) this cannot be split equally
i want to use the countif function to see how many "bigs" there are for example and then allocate the accounts to them
let’s say i have 4 big, 19 Medium and 8 Small users and my total accounts is 41427, i need the 41427 split between them using the numbers above
i will attach my spreadsheet, i want to be able to just change the total (in yellow) and the formula to run through and change results of how to split population (in green) - this should also at bottom again total to 41427
you will see my formulas and used and hopefully understand what i tried to do, i am stuck
i used the following to identify the split in columns H - K
=COUNTIF(B4:B24,"big") | |
=COUNTIF(B5:B25,"medium") | |
=COUNTIF(B5:B25,"Small") | |
=COUNTIF(B5:B25,"No_Handover") and the following to accumulate final results in column D -
|