Excel If formula sum not blank

Closed

joanie - Dec 3, 2009 at 04:56 PM
joanie - Dec 8, 2009 at 08:36 PM

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

Excel If formula sum not blank
Excel grade formula - Guide
Number to words in excel formula - Guide
Date formula in excel dd/mm/yyyy - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Excel free download - Download - Spreadsheets

2 responses

Answer 1 / 2

joanie
Dec 8, 2009 at 08:36 PM

Thank you very much for your help!

Answer 2 / 2

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 4, 2009 at 05:50 AM

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

use this formula

=SUMPRODUCT(($B$2:$B$6<>"")*($A$2:$A$6))

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

encryption message several time in chat

Similar discussions

Subscribe To Our Newsletter!