Calculating cost based on criteria

LUIS FREUND
LUIS FREUND used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You can use this
=SUMPRODUCT((L2:L13="")*F2:F13)

Author

Commented:
AWESOME!  Thank you!
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You may also use SUMIF function to get the desired output...

=SUMIF(L2:L13,"",F2:F13)

Open in new window

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial