Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #789 Oct 01, 2012 www.energyefficientbuild.com.
user TravisAP said: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/-QAhpCtieJM)
Concatenate Text As Argument?
I want the count range to dynamically expand.
=count("B7:B" & rows(B:B))
That returns 0.
How can text be concatenated as an argument?
----
following is a solution to the problem
user TravisAP said: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/-QAhpCtieJM)
Concatenate Text As Argument?
I want the count range to dynamically expand.
=count("B7:B" & rows(B:B))
That returns 0.
How can text be concatenated as an argument?
----
user Kishan_ said
....I am curious to know, is there a solution that I have posted my previous post??, i.e. can we count in each row in iteration??
If yes then what would be the formula in Cell C7 to get the Expected results??
Thanks,
Kishan
--------------------------------------------------------------------------------------------
following is a solution to the problem
