Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif Problem
Hello,
I have an issue using sumif. I am trying to sum a column if the work area equals a certain value, but I only want it to sum values that are not duplicates. For example, A B C D E Work Area Part Price of Part Qty of Parts on hand total cost of inventory Multiple work areas use the same part, which is why I am selecting the value for the work area. I am summing column E. But a work area could have ordered the same part multiple times, and I do not want to sum up duplicate values from column E for the same part. If anyone could help me with an array function, I would greatly appreciate it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
importing csv files, problem with date formats | Excel Worksheet Functions | |||
sumif problem | Excel Discussion (Misc queries) | |||
Problem with SUMIF criteria | Excel Discussion (Misc queries) | |||
SUMIF problem | Excel Worksheet Functions |