Excel If formula sum not blankClosed

Question

Hello,
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
14                               
20                              Claims
25                              CRU 
35
75                              HR

I need a formula that will sum column A if column B has value/text,  

thanks in advance for your help

Joanie

venkat1926 · Answer

row 1 contains column headings and data is from A2 to B6

use this formula 

=SUMPRODUCT(($B$2:$B$6<>"")*($A$2:$A$6))

joanie · Answer

Thank you very much for your help!

Excel If formula sum not blank

2 responses

Similar discussions

Subscribe To Our Newsletter!