I have a worksheet that I am working on to purchase equipment. I have
multiple duplicate items to be ordered that are seperated by departments. I
want to be able to calculate the duplicate items so that I will see how many
ordered per that that particular item no matter which group they come from
....basically a total for that particular item ordered not a breakdown