LUIS FREUND
asked on
Calculating cost based on criteria
Wanted to calculate "NOT ON ORDER COST" at L17 based on blanks from a different column. For example in column L if it's blank than I wanted the base total cost from column F to be summed up at L17. Highlighted in yellow,
See attachment.
C--Users-lfreund-Downloads-COST.xlsx
See attachment.
C--Users-lfreund-Downloads-COST.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You may also use SUMIF function to get the desired output...
=SUMIF(L2:L13,"",F2:F13)
ASKER