#Invalid Data Type (Column formula)

Ed Freeman

I think I found my issues and need to see if there is a work around, as it worked last year and this year it stopped.

I have a sheet the summarizes data by month. In one column the formula works fine and the next column I get the #Invalid Data Type.

The one that work is - =SUMIFS({SY Project Data - Sales Price}, {SY Project Data Order Closed}, MONTH(@cell) = 1). It sums the sale price for order closed in January, works great.

This one returns the error - =SUMIFS({SY Project Data - Profit}, {SY Project Data Order Closed}, MONTH(@cell) = 1). It should sum the profits on the order closed in January, but it does not. The only difference I see is that the column "SY Project Data - Profit" is a Column Formula.

Is there a work around for this?

Thank you in advance for your help!

Amit Wadhwani

Hi @Ed Freeman

Looks like the column type in one of these columns is not set correctly. For example, if you are using a formula to calculate a date and the source column does not contain a date, it returns similar error. Can you check this?

Paul Newcome

What is the formula in the "SY Project Data - Profit" column?

Also, as a best practice, wrap any date based functions in an IFERROR when referencing an entire column. If there is even one blank or non-date value in the date column, it will throw an error.

IFERROR(MONTH(@cell), 0) = 1