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