If Then Formulas

Mike Wilday

I just started experiencing the block issue yesterday. Its quite annoying.

Andrée Starå

@Mike,

Haven't you've seen it previously at all? Lucky you!  

Welcome to the club! 

Mike Wilday

Haha. No, this is my first time. I thought this was a recent update to the community but perhaps I am mistaken! 

Andrée Starå

Everything is relative! It's been annoying me for the last month. 

Crystal Panning

The CountIF formula worked, thank you all!

Mike Wilday

Glad we could get this sorted out for you. Teamwork makes the dream work. 

Andrée Starå

Excellent!

Happy to help!

Crystal Panning

For the countIF formula, since it uses a range, if new line were continuing to be added to the sheet, would I have to keep updating the range in the formula, or is there a way for this to automatically update? 

Paul Newcome

Happy to help! 

 

[Column Name]:[Column Name] is referencing an entire column. It will include new rows. The only time you would need to update a range to account for new rows is if you specified row numbers such as [Column Name]1:[Column Name]5.

Crystal Panning

Amazing, thank you!