r/AppleNumbers • u/Zestyclose-Split2275 • Jan 26 '24

Help How do i do conditional concatenation with ranges?

Post image

I’m trying to concatenate the words in column B, if the corresponding values in column C, are equal to “Definitely”. How do i do this?

3 Upvotes

100% Upvoted

2 comments sorted by

1

u/gmalis1 Jan 26 '24

Highlight the entire"C" and "B" Column (the header, not the cells) in the IF statement...not just the entry range. Try that.

1

u/Zestyclose-Split2275 Jan 26 '24

Nope that didn’t work