Calculating Duplicate Cells
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 |
Calculating Duplicate Cells
=SUMIF(A1:A100,"item #",B1:B100)
where column A is item number column B is quantity ordered "item #" is the item number Or I have misunderstood? "RicoHoward" wrote: 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 |
All times are GMT +1. The time now is 07:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com