Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up data.
Howdy. I have been trying to figure out how to do the following;
Example Columns: Date, ItemCode, Desc, Units. On another sheet, I have Item Code, Date, Units, followed by dates in row 1. I need to sum all the units that match Item Code, Date. I just don't know how to do it. I've tried to use and(), but have not received the desired results. Can you help me? I really want to be able to do this. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up data.
Hi,
You could try this =sumproduct((range1=A2)*(range2=B2)*(range3)) range1 is the range on sheet 1 which has the item code range2 is the range on sheet 1 which has the dates range3 if the range on sheet 1 which has the units -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Kewlstix" wrote in message ... Howdy. I have been trying to figure out how to do the following; Example Columns: Date, ItemCode, Desc, Units. On another sheet, I have Item Code, Date, Units, followed by dates in row 1. I need to sum all the units that match Item Code, Date. I just don't know how to do it. I've tried to use and(), but have not received the desired results. Can you help me? I really want to be able to do this. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up data.
Try Sumif.
=SUMFI(range,criteria,sum range) =SUMIF("Date Range", "Date Criteria","Unit") =SUMIF("ITEM CODES RANGE", "Particular Item Code","Unit") Have a look in sumif examples in help menu. If this post helps, Click Yes! -------------------- (MS-Exl-Learner) -------------------- "Kewlstix" wrote: Howdy. I have been trying to figure out how to do the following; Example Columns: Date, ItemCode, Desc, Units. On another sheet, I have Item Code, Date, Units, followed by dates in row 1. I need to sum all the units that match Item Code, Date. I just don't know how to do it. I've tried to use and(), but have not received the desired results. Can you help me? I really want to be able to do this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Labels- POssible to show data value and data label together? | Charts and Charting in Excel | |||
Increase Your Business By Data Conversion, Data Format and Data EntryServices in India | Excel Worksheet Functions | |||
Save 20% On Data Conversion and Data Formats Services by Data EntryIndia | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
MULTIPLE DATA - How to insert new data into existing data.... | Excel Discussion (Misc queries) |