Help with IFBlank

[silvibins]

Hi, I'm new to this forum and signed up in the hope someone could help me with something I've been trying to figure out for hours without success, including going through the forum here, searching for IFBlank - maybe that's what I don't even need.

My data set looks like below with Q1_round1, Q1_round2, Q1_round3: Each respondent could get a chance to answer Q1 in either round 1, 2 or 3 or maybe he was not chosen for Q1 and in that case the cell should be empty.

Essentially: find the value either here or here or here and if everything is blank then leave it blank.



var1[TABLE="width: 500"]
<tbody>[TR]
[TD]Q1_round1[/TD]
[TD]Q1_round2[/TD]
[TD]Q1_round3[/TD]
[TD]Q1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

 

[silvibins]

Sorry, pressed the hit button before I could add: I would appreciate any help! I've been copy pasting for hours :/

 

[FDibbins]

maybe something like...
=if(counta(range)=0,"",counta(range))

 

[silvibins]

Thanks for replying! The data set is unfortunately not set up so that a range would work - I simplified it above. It's more like: Q1_round1_product1, Q1_round1_product2, Q1_round1_product3 etc. all the way to product 66 and then it starts all over for round 2.

So, what I'm trying to tell Excel is "Take the value from cell 1 (e.g. A3) or cell 2 (e.g. F3) or cell 3 (e.g. H3), if all 3 of those cells are empty, leave it blank."

 

[NiMip]

Assuming there's only ever one entry, and are the values always numbers or words?

If they're always numbers, could do =IF(SUM(A3,F3,H3)=0,"",SUM(A3,F3,H3))
If they're words/text, could simply do =CONCATENATE(A3,F3,H3)

 

[silvibins]

That worked!! Thank you so much, NiMip!