Forum Discussion
Counting issue
I'm looking for some guidance on an issue I've run into when working on a spreadsheet. I'm looking to count the number of times an item comes up, but the kicker is, there's a multiplier on the items sometimes. I want to measure how much product is being thrown away and when my team exports the data, the entered information can vary. For example, they can throw the same item away twice, causing the data to populate a 2 in the column to the right of the item, instead of populating the same name twice. Any help to have the information count that same item twice based off of the data is greatly appreciated!
Regards,
Chris
- Can you provide some samle data please?
Please provide sample data.
If throwing away 1 time an item causes the column to the right to have "1", you can use the SUM.IF function that allows you to SUM every number in the column of the right IF on the left there's a particular item.
Because of this, you need a "resume chart" with all items stated in which you insert this formula, and this will give you the totals.
Do you want something like this?
Regards,
Hitesh Gaur
So, here it is.
You have in Column A the name of the item (must be the same for all the same items; remember that "item1" is different from "item 1" and from "item1 " or "item 1 "; you must use always the exact characters).
In Column B you have the times that the item was thrown away.
In the yellow cells there is the formula to sum all item 1 (regardless if in the A column it figures 1 time or 100).
You need the list of all items available (even if they are not yet in column A, I suggest). If an item is in this list but it does not figure in the A column, the result is 0 of course.
I also suggest that the yellow cells (check the referrals to the cells, I used till row 6 or whatever but you can always put 600 6000 or whatever) should be put in a different sheet/tab, in order to have a sort of "resume" of all the datas.
