=Count not pulling number from cell on reference sheet

DHewitt

I have the formula =COUNT({Demo Room test requests Number of assemblies}) in a sheet which is counting the number of times there is a value entered into that row, not the actual value in the cell. It pulls "1" as the value instead of "5".

Example 1

Example 2

J Tech

Hi @DHewitt

The formula you are using, =COUNT({Demo Room test requests Number of assemblies}), will only count the number of non-empty cells in the specified range, in this case, the {Demo Room test requests Number of assemblies} column. It sounds like what you want is to sum the values in the cells, rather than count the number of non-empty cells.

To do that, you can use the SUM function instead of the COUNT function. Try using this formula instead:

=SUM({Demo Room test requests Number of assemblies})

This formula will add up all the values in the {Demo Room test requests Number of assemblies} column, giving you the total value.

J Tech

Hi @DHewitt

The formula you are using, =COUNT({Demo Room test requests Number of assemblies}), will only count the number of non-empty cells in the specified range, in this case, the {Demo Room test requests Number of assemblies} column. It sounds like what you want is to sum the values in the cells, rather than count the number of non-empty cells.

To do that, you can use the SUM function instead of the COUNT function. Try using this formula instead:

=SUM({Demo Room test requests Number of assemblies})

This formula will add up all the values in the {Demo Room test requests Number of assemblies} column, giving you the total value.

DHewitt

@J Tech Thank you. Am I able to add a conditional for it to only count a row if the "Complete" check box is not checked?

J Tech

Hi @DHewitt

=SUMIFS({Demo Room test requests Number of assemblies}, Completed:Completed, false)