Dear Excel community,
I'm learning counting functions and noticed that they give me wrong answers when referring to a range containing formulas.
Please refer to range K3:K9 and feel free to comment
https://docs.google.com/spreadsheet...VpN6C6698ZKdv_ybBuxrkKNz8/edit#gid=1299953844
https://docs.google.com/spreadsheets/d/1mbVFXspU9ml1_epBhIVpN6C6698ZKdv_ybBuxrkKNz8/edit?usp=sharing
Many thanks in advance
I'm learning counting functions and noticed that they give me wrong answers when referring to a range containing formulas.
Please refer to range K3:K9 and feel free to comment
https://docs.google.com/spreadsheet...VpN6C6698ZKdv_ybBuxrkKNz8/edit#gid=1299953844
https://docs.google.com/spreadsheets/d/1mbVFXspU9ml1_epBhIVpN6C6698ZKdv_ybBuxrkKNz8/edit?usp=sharing
Many thanks in advance