SUMIFS referencing a date column

Cara Parfitt

Hoping someone can help with what I'm sure is a painfully simple fix.

I'm getting INVALID COLUMN VALUE with the following formula. I've researched this error and it doesn't seem like the column type should be anything except text/number.

=SUMIFS(Qty:Qty, SKU:SKU, "BW-8x5", Status:Status, "Complete", [Date Complete]:[Date Complete], IFERROR(MONTH(@cell) = 1, ""))

Thanks in advance

Frank Falco

Give this a try

=IFERROR(SUMIFS(Qty:Qty, SKU:SKU, "BW-8x5", Status:Status, "Complete", [Date Complete]:[Date Complete], MONTH(@cell) = 1), "")

What is the type of the column this is in?

Cara Parfitt

Hi Frank,

Thanks so much! The IFERROR at the beginning did the trick.