SOLVED Invalid Value with COUNTIFS Formula

Lisa Kennedy

SOLVED: there were a few invalid values in there causing the counts to not work properly. Lesson learned

Hi,

I have a COUNTIFS formula that works just fine with my Contact Column data but is not working with a text column; it gives the Invalid Value error. This is the COUNTIFS formula

=COUNTIFS([Account Director]:[Account Director], [Account Director]@row, [Contract End Date]:[Contract End Date], "", [YTD Goal Pacing]:[YTD Goal Pacing], >[Day of Year]@row).

The Contact Data is actually an index(collect formula and the Text Data is also a formula. It's a simple IF formula but it seems to be making my formula not work. If I use pasted data, it works fine but if it's a formula, it's not counting as expected. Does anyone have a solution?

Thanks,

Lisa

Andrée Starå

Hi @Lisa Kennedy

I hope you're well and safe!

Glad that you solved it!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!