Sumifs with date column returning #Invalid Data Type

KenR

I'm attempting to use the sumifs formula and it is returning the error "#Invalid Data Type"

=sumifs(Number:Number,[Date Column]:[Date Column],[Date Column]@row, Name:Name, Name@row)

[Date Column] is a date column type; Number is a text/number with a formula that returns an integer; Name is a text/number with text inside

I've confirmed all values in [Date Column] are valid dates.

What am I missing?

The data table is like:

name | Date | Number

###A | 1/1/24 | 1

###B | 1/1/24 | 2

###C | 1/2/24 | 3

###A | 1/1/24 | 4

KenR

Someone entered a row without a date and the blank caused the error. When I checked the date values I missed the blank.

I deleted the errant row with the blank date and the formula worked.

KenR

Someone entered a row without a date and the blank caused the error. When I checked the date values I missed the blank.

I deleted the errant row with the blank date and the formula worked.

Marcela

Hey @KenR

Thank you for posting your solution. I'm glad you got this resolved!