Archives June 2023

=SUMIF(CriteriaRange,Criteria,SumRange)

I signed up to Sling with an email address that I created solely for Sling membership, however, I have been getting SPAM into that email address. My only reasoning is that they sold my email address. I created an email sch as TV@domain.com, which was meant only for Sling TV. How can other people know my email address if I only gave it to Sling? When you set up you account for services like Sling, Roku, etc., create a unique address for those services, that way you know who’s selling your “private” information.

=TEXTJOIN(", ",TRUE,A1:A3) 

• TRUE = Ignores empty cells
• FALSE = Includes empty cells (so you may end up with blank delimiters)