Monday, October 1, 2012

yogi_Compute Progressively Increasing (Cumulative) Number Of Numeric Entries In A Column

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #789  Oct 01, 2012

user TravisAP said: (!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??


following is a solution to the problem