Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Cells | Excel Worksheet Functions | |||
Duplicate cells | Excel Discussion (Misc queries) | |||
Duplicate cells | Excel Discussion (Misc queries) | |||
duplicate cells | Excel Discussion (Misc queries) | |||
Duplicate Cells | Excel Discussion (Misc queries) |