Excel - If formula sum not blank

October 2016


I'm sorry if my question had already been asked before but I can't find any answer in the internet about summing all values that is not blank.

For example:

Column A Column B
20 Claims
25 CRU
75 HR

I need a formula that will sum column A if column B has value/text,

Thanks in advance for your help


Row 1 contains column headings and data is from A2 to B6

Use this formula:


Thanks to venkat1926 for this tip on the forum.

Related :

This document entitled « Excel - If formula sum not blank » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.