Sign in to join the conversation:
Attached is a sample screen shot of 6 names. On the seventh cell, what formula do I input so it reads "6"? I need a way to sum up all of the names in a column.
You can use something like this:
=COUNTIF(Range:Range, NOT(ISBLANK(@cell)))
or just =
count(Name1:Name6)
would work.
I would have to agree with L@123's solution for this one. If you are referencing the entire column, you will get a #CIRCULAR REFERENCE error since the formula is within the range.
Hi all, I have a form where people request a guide be created. Once that submission is complete, I have to take several of those data points and create a workflow template. Is there any way to take the data from a row and map it to the template to create the client specific sheet automatically? I am thinking of something…
I have a Portfolio Dashboard, In tht we have multiple domains and each domains have multiple projects. I have created a main Dashboard which is having a link of Portfolio and each domain overview dashboard. I have individual project Dashboard also Now in each domain Dashboard i want to include a project selector and as…
I have a dashboard series of reports that have the sum of all room populations for the specified spaces in the report summary. Is there a way to capture the summary from these reports? I want to have a text box that displays these sums… I am trying to avoid having to setup yet another helper column to count up these spaces.
