I'm getting an "Invalid Data Type" error

deb_63_hydracor

Hello,

I'm trying to count all rows (using a cross-sheet reference) which have either "Discovery Call - Scheduling" or "Discovery Call - Scheduled" in the Sales Status column but am getting an "Invalid Data Type" error.

Thanks you.

Jeff Reisman

@deb_63_hydracor

What is the column type of the column containing your formula? If it's not a Text/Number column, you can get this error when trying to calculate a number value.

You're missing a close parentheses at the end of your formula. Notice how the opening blue parentheses does not have a matching blue at the end? You have to close off both the OR statement and the COUNTIF formula.

You could also try adding @cell = to your criteria:

=COUNTIF({Sales Status}, OR(@cell = "Discovery Call - Scheduling", @cell = "Discovery Call - Scheduled"))

Jeff Reisman

@deb_63_hydracor

What is the column type of the column containing your formula? If it's not a Text/Number column, you can get this error when trying to calculate a number value.

You're missing a close parentheses at the end of your formula. Notice how the opening blue parentheses does not have a matching blue at the end? You have to close off both the OR statement and the COUNTIF formula.

You could also try adding @cell = to your criteria:

=COUNTIF({Sales Status}, OR(@cell = "Discovery Call - Scheduling", @cell = "Discovery Call - Scheduled"))