Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional sumproduct? no idea.
Please Help!
On one part of the spreadsheet I have a resource schedule of employees and what they should be working on during a specific week (columns B&C). Column A Column B Column C Jack EAS EAS Ted Optimum BSN Carl Twin Labs Optimum Bill EAS Optimum On another part of the same spreadsheet I have stages (column Y) and the price per unit (column Z) for each account (column X) Column X Column Y Column Z EAS Shipping 25.50 Optimum Packaging 30.29 Twin Labs Shipping 19.95 BSN Labeling 35.78 So I need to calculate if an account is in the shipping stage what the total of column Z per week (columns B&C). For Week 1 (column B) it would be 70.95 and for week 2 (column C) it would be 25.50. HOWEVER, the bigger issue is that all of these fields are constantly changing so the formula needs to be open for future iterations. I've tried this =SUM((SUMPRODUCT ((B2:B5=X1)*Z1)),((SUMPRODUCT ((B2:B5=X2)*Z2))...etc. which will give me the total amount but I can't seem to work in the "if" condition for the shipping status. Any thoughts? there's gotta be a better way |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
I've no idea how to do this. :( | Excel Worksheet Functions | |||
any idea? | Links and Linking in Excel | |||
any idea?? | Excel Worksheet Functions | |||
Help Please. No Idea what to look for or how to do this | Excel Discussion (Misc queries) |