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


Open in new window

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.