#INVALID DATA TYPE Error

Angela Cisneros

I am receiving an #INVALID DATA TYPE Error when I have blanks in the dates I am referencing. The formula is summing the equipment pieces based on the delivery month, but the delivery date can be added later in the project, so there will often be blanks. My formula is below:

Adding an IFERROR avoids the error message, but I would like for the formula to work for the data that is present in the other months. It is feeding a chart that is a lot less meaningful without the not accepted showing up.

Any ideas on this? Appreciate your help in advance!

David Joyeuse

Hi @Angela Cisneros

Just add an ISDATE function to your SUMIFS so it only takes Dates into account.

Your formula would be like this then:

=SUMIFS({Summary Roll-Up - Equipment}, {Summary Roll-Up - Latest Delivery}, AND(ISDATE(@cell),MONTH(@cell)=Value72))

Also, you can use the IFERROR on the MONTH function:

=SUMIFS({Summary Roll-Up - Equipment}, {Summary Roll-Up - Latest Delivery}, IFERROR(MONTH(@cell), 0)=Value72)

Hope it helped!

David Joyeuse

Hi @Angela Cisneros

Just add an ISDATE function to your SUMIFS so it only takes Dates into account.

Your formula would be like this then:

=SUMIFS({Summary Roll-Up - Equipment}, {Summary Roll-Up - Latest Delivery}, AND(ISDATE(@cell),MONTH(@cell)=Value72))

Also, you can use the IFERROR on the MONTH function:

=SUMIFS({Summary Roll-Up - Equipment}, {Summary Roll-Up - Latest Delivery}, IFERROR(MONTH(@cell), 0)=Value72)

Hope it helped!

Angela Cisneros

Thanks for those suggestions. The ISDATE did not work, but the IFERROR on the month did.

Thanks!