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