Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW TO COUPLE VLOOKUP & SUMIF
Hello!
1) I have two tabs, namely, Tab 1 and Tab 2 2) Tab 1 has two headings, namely, "Work Order Number" and "Total". Underneath would be a list of work orders. 3) Tab 2 has two three headings, namely, "Date", "Work Order Number" and "Amount". This is a list of work order numbers in random with dates and amounts. The amounts could be positive as well as negative. I am look for a formula under the heading "Total" in the Tab 1, which will do the following: a) The formula will look at the 'Work Order Number' beside it and then try to locate that work order number in Tab 2. b) If it finds that work order number in Tab 2 then it will sum all the various amounts showing up against the work order. c) If it does not find the work order then either it can show zero or blank. Thanks for the help ion advance SJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Couple of Questions Need Help Please..... | Excel Discussion (Misc queries) | |||
A couple of questions | Excel Discussion (Misc queries) | |||
Couple of vlookup queries | Excel Worksheet Functions | |||
Couple more questions... | New Users to Excel | |||
There are a couple of parts to this ???...Thank you for the help. | Excel Worksheet Functions |