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
LUIS FREUNDAsked:
Who is Participating?
 
Ejgil HedegaardConnect With a Mentor Commented:
You can use this
=SUMPRODUCT((L2:L13="")*F2:F13)
0
 
LUIS FREUNDAuthor Commented:
AWESOME!  Thank you!
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You may also use SUMIF function to get the desired output...

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

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.