Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct
I have two conditions I need to sum on 2 different worksheets:
Worksheet1 Column A2 John Doe Worksheet2 Column A2 Column B2 Column C2 John Doe 1 2 John Smith 2 I need to: If A2:A100 in Worksheet2 = columnA in Worksheet1 and column B in Worksheet2 <1 Sum up Column C in worksheet1 in B2, otherwise 0 So in this instance B2: John Doe would be 0, but John Smith would be 2. I hope I haven't made it too confusing. Please help. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
Need help with sumproduct and dynamic ranges | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |