Microsoft Office Forums - View Single Post - [Solved] have a formula that combines two cells return a zero instead of a blank cell

Thread: [Solved] have a formula that combines two cells return a zero instead of a blank cell

View Single Post

Old

08-07-2017, 07:53 PM

Logit

Logit is offline

Logit uses Windows 10

Windows 10 Logit uses Office 2007

Logit uses Office 2007

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Default

Code:

=IF(COUNTIF($I$2:I2,I2)=1,SUMIF($I$2:$I$433,I2,$H$2:$H$433),"0")

Paste J2 and drag down

Reply With Quote