Forum Discussion
Counting issue
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.