Forum Discussion

jaolvera's avatar
jaolvera
Brass Contributor
Jul 18, 2023

Total months Formula

Hello!  Is there a formula I could use for each cell listed by month (see photo) that I could use that would total the amount of times each month was referenced in a range of dates. Ex. lets say Co...
excel
peiyezhu's avatar
peiyezhu
Bronze Contributor
Jul 18, 2023
=COUNTIFS(A2:A10,">="&DATE(year,month,1),A2:A10,"<="&DATE(year,month+1,1)-1)
jaolvera's avatar
jaolvera
Brass Contributor
Jul 18, 2023
besides changing the cell range was anything else supposed to be changed in this formula? all I get are 0 for the totals
  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor
    Jul 19, 2023
    =COUNTIFS(A2:A10,">="&DATE(2023,1,1),A2:A10,"<="&DATE(2023,1+1,1)-1)

    data
    A
    date
    2023-01-15

Resources