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

BigTexx

=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

Bassam Khalil

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