Sheet Summary Formula #Invalid Data Type

AaronM

I have a countifs formula that is returning #invalid Data Type error in the sheet summary. The reason for the error is that I have blank cells in the finish date column range. How would I add an iferror or something similar to the following formula to cause it to ignore the blanks?

=COUNTIFS([Renovation Complete]:[Renovation Complete], true, [Finish Date]:[Finish Date], (VALUE(MONTH(@cell)) = 6))

Thank you in advance for your help

Mike Wilday

Try wrapping your Month(@ cell) in an IFERROR formula like below. It will set all blank fields as 0 which will ignore them.

=COUNTIFS([Renovation Complete]:[Renovation Complete], true, [Finish Date]:[Finish Date], IFERROR(MONTH(@cell), 0) = 6)

Hope that helps!

AaronM

Thank you, Mike. That did work. I had tried that prior and couldn't get the paranthesis in the right spots. You nailed it. Appreciate the support and quick response.

Mike Wilday

If you could accept my answer that would be greatly appreciated. It looks like you accepted your own. :)

Mike Wilday

Try wrapping your Month(@ cell) in an IFERROR formula like below. It will set all blank fields as 0 which will ignore them.

=COUNTIFS([Renovation Complete]:[Renovation Complete], true, [Finish Date]:[Finish Date], IFERROR(MONTH(@cell), 0) = 6)

Hope that helps!

AaronM

Thank you, Mike. That did work. I had tried that prior and couldn't get the paranthesis in the right spots. You nailed it. Appreciate the support and quick response.

Mike Wilday

If you could accept my answer that would be greatly appreciated. It looks like you accepted your own. :)