Your question is misleading (well to me anyway). In the first sentence you ask for a formula to sum F for rows where C = blank. Then in the second sentence you ask for a formula to disregard cells that have nothing in them (presumably you mean column C).
Are these two separate questions or have you just got mixed up?
To sum F where C is blank you could use:
To sum F where C is not blank you could use:
If neither of those fit your needs, post a sample workbook, show your expected result(s) and explain how you arrived at them.
BSB
Bookmarks