Counting values to create a unique total

Hey guys,

I am somewhat new to excel but I am trying to create a spreadsheet to keep track of specific numbers on a weekly basis.

What I have is four seperate cells and each cell will be filled with a specific number depending on how many get accomplished.

So, A,B,C,D with seperate numbers for each.

Next, I need excel to calculate (if it can) a total for these values, except here is the challenge. For every 3 of the 4 cells that have a 1, it creates a bundle. The bundle total will be displayed in another cell. So, lets say A and B have 1, but C has 3 and D 0.

That means there is 1 complete bundle because ABC all have one. I would need it to calculate this for every 3 of 4, creating another total for the bundles. So if there were 4 bundles, it could be a mix of any 4 of those cells as long as it satisifies the 3 of 4 of those cells 4 times.

I have no idea if this makes sense, but hopefully someone can decipher what I mean.

Thanks

Sorry about that...Lets see if this helps

So a bundle is defined by 3 or more products for this situation. I want to keep track of each product seperately and have excel calculate the amount of bundles I have achieved.

Product A - 3 sales
Product B - 2 sales
Product C - 1 sales
Product D - 1 sales

Total bundles = 2

Sale of product A, B and C = 1 bundles
Sale of product A, B and D = 2 bundles

I am in sales and we have to track how many bundles we sell instead of individual products, but the bundles can be any variation of those 4 or more products.

Is this kind of what you were looking for? My excel sheet is nearly blank since I have no idea how to do the calculation.

Manually calculated answers, sorry this is complicated.


TODAY’S SALES

Account sales - 3
COPS – 0
Credit product - 2
Insurance - 1

BUNDLES SOLD – 1 (1 account, 1 credit product and insurance makes the bundle)


YESTERDAY’S SALES

Accounts – 4
COPS – 2
Credit Product – 2
Insurance – 0

BUNDLES SOLD – 2 (1 account, 1 COPS, 1 credit product makes 1 bundle, the other bundle is made up of the same as the first – complete 2 bundles)


MONDAY’S SALES

Accounts – 3
COPS – 1
Credit Products – 3
Insurance – 2

BUNDLES SOLD – 3 (1 account, 1 COPS, and a Credit product makes 1 bundle. 1 account, 1 credit product and insurance makes the 2nd bundle and the 3rd is the same as the 2nd bundle making 3 bundles)



A bundle consists of any combination of 3 or more products (Account, COPS, Credit product, and insurance) The bundle does not have to have all 4 products sold, but any combination of the 3 will satisfy a bundle.

I don't really have any data on the spreadsheet because I haven't really figured out a way to calculate it. I am a little inexperienced with excel, but I have a basic understanding of some functions.

As for the bundles, I don't intend for it to be a decrementing issue. I keep track of the products seperately because I do not need them all in one sale.

So I could potentially sell an account, then with a totally seperate client sell a credit product with insurance and that would in essence create the bundle that my management is looking for. However, in that same day, I may not sell any COPS but I still have sold 3 products to meet the bundled requirements.

Do you want me to put the data into a spreadsheet still? I just haven't figured out how to manually calculate/show the data accurately in excel...