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
Hi Yogi,
ReplyDeleteExcellent... I must say you are the best in this field and you are having very deep knowledge of each and every formula of Google Spreadsheet.. :)
Thank you so much..!!!
Hi Kishan:
ReplyDeleteThanks for your generous comment -- for me participation in this forum is certainly a great learning experience from contributions of experts such as Adam, Anand, David, Gill, Ted, yourself, and others ... Now Let us Keep Googling.
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com