How to give a If condition significantly while copying text join formula values from one cell to required cell

[Shanmugaraj N]

Hi,
Here I have to applying the text join in G column from row 2. I need to want give text join in G Column from row 4 , row 6, row 8. The condition is need to apply for related to Column B in "F" only. How to give IF condition with related column B in " F ". Please give the solution for doing this scenario.

 

[Fluff]

How about

=TEXTJOIN(",",,IF(B2:B10="F",C2:F10,""))

This will probably need to be confirmed with Ctrl Shift Enter, rather than just Enter.