I am trying to formulate it to where a single number is counted with a month each month.

Options

=arrayformula(COUNTIF('FTA/FTO Ride Along Tracking Form Responses'!D2:D & 'FTO Work Order Responses'!C2:C, E5:E))

This is the formula that I am using to count a single number how ever many times it shows up in the responses. I want to count this number as it appears with in a month. So evetime this number shows up in a January date it will count. Evetime this number shows up in a February date it will count, etc...


Can someone help

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 02/04/21
    Options

    Hi @BigTexx

    Hope you are fine, please try the following formula and convert it to column formula.

    =IFERROR(COUNTIFS([single number]:[single number], [Number To Count]@row, Date:Date, MONTH(@cell) = 1), "") for January

    And

    =IFERROR(COUNTIFS([single number]:[single number], [Number To Count]@row, Date:Date, MONTH(@cell) = 2), "") for february

    and so on you cange the month number due to month


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!