Cross Sheet Reference Formula

02/28/21
Accepted

I am trying to write a cross reference sheet formula to count MTD dates in a column using this formula I found here but it is not working. Thoughts?

=COUNTIFS({Andee Metrics Terms}, AND(IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), IFERROR(MONTH(@cell), 0 = MONTH(TODAY()))))

Best Answer

  • Kelly MooreKelly Moore ✭✭✭✭✭
    Accepted Answer

    Hey @Corporate Corporate

    Is your {Andee Metrics Terms} a date column? Also, we need to rearrange a parenthesis or two

    =COUNTIFS({Andee Metric Terms}, AND(IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), IFERROR(MONTH(@cell), 0) = MONTH(TODAY())))

    cheers

    Kelly

Answers

  • Kelly MooreKelly Moore ✭✭✭✭✭
    Accepted Answer

    Hey @Corporate Corporate

    Is your {Andee Metrics Terms} a date column? Also, we need to rearrange a parenthesis or two

    =COUNTIFS({Andee Metric Terms}, AND(IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), IFERROR(MONTH(@cell), 0) = MONTH(TODAY())))

    cheers

    Kelly

  • Thank you, yes was a date column, those pesky parenthesis :<

  • Kelly MooreKelly Moore ✭✭✭✭✭

    😃 Yes, pesky indeed! I wish I had a nickel for every time they have hung my formulas up.

    I'm glad we have it working now

Sign In or Register to comment.