Forum Discussion
Setting up multiple combinations of groups, and adding to test for a certain output. HELP?
I've been setting up a spreadsheet that has over 200 different items. Each item has 5 values. Each value ranges from -100 through 100. What I am wanting to find is if any combination of 3 to 5 of dif...
I can able to understand this little bit only.
I can't get you, what you want?
Can you explain them in excel term.
For Eg.
You have item names in Column A.
And your values for that items in B,C,D,E,F Columns.
You want to check, whether if you put SUM function for range of "B2:F2" for each item, it results "zero" or put SUM for each group of item.
If not, ask your requirements one by one. Then only i can solve.