Forum Discussion
Formula Assistance
Column A would be initials of different employees, so it would contain multiple different values. Column B is a quantity of material packaged. What I am looking to do is have excel move the values from Column B to a specific cell in Column C that is assigned to each individual employee and be auto summed.
If the same as B2:B3, the formula in C2 is simply:
=B2
I hope this is better, as I am obviously not an expert excel user!
What I am looking for is a formula that will take the values in the B column, based on the values in the A column, and put them into the D column. Also would like the D column to auto sum the numbers from the B column. The colors are just used for illustration purposes.
The formula you need is SUMIF (or SUMIFS)
= SUMIFS( Bcolumn, Acolumn, "abc" )
You have decisions to make as to how you can best reference the data in columns A and B and how to avoid the labour intensive process or hard-wiring the name "abc" etc. in each formula.
- Perhaps, you want Column C to return the unique employee initials and Column D to return the sum of the numbers in Column B for each employee initial. Please cite sample results for Column C also.
- How come Column C is now blank? How can we identify the cells in Column A that would be summed in Column D?
By their color apparently :-)
