Count

Lakshman .

Hi

How can i count no of surveys submitted on real time? I tried to write count if formula but it need a constant range, but every day we get new submissions. is there any way to count?

Sean Morgan

Hello @Lakshman . ,

You may want to try =COUNT([Survey Completed]:[Survey Completed]. This will count all the values in the Survey Completed column.

Please reach out if this does not work.

Regards

Sean

Ryan Nix

Do you have a specific example you're trying to solve for?

You could probably use this formula for a column that will always be populated by your new submissions (e.g. your primary column or created column)

=COUNT(Column1:Column1)

That number should continue to count as you get new submissions in real time.

Lakshman .

Hi Ryan

thanks for reply, it appears to be working but still it is showing 2 as total count when i entered the following formula.(still it seems i have give range of cells in the column)

Sean Morgan

Hello @Lakshman . ,

You may want to try =COUNT([Survey Completed]:[Survey Completed]. This will count all the values in the Survey Completed column.

Please reach out if this does not work.

Regards

Sean

Lakshman .

thanks it works