hard20 pts · first answer countsexcelconditional-functionsdates

Monthly total from a date column

Dates are in A2:A5000 and amounts in C2:C5000. F2 holds 1-Mar-2026. Which formula totals March 2026 correctly?

A.=SUMIFS(C:C,A:A,">="&F2,A:A,"<"&EDATE(F2,1))B.=SUMIFS(C:C,A:A,">="&F2,A:A,"<="&EOMONTH(F2,1))C.=SUMIFS(C:C,A:A,">="&F2,A:A,"<="&F2+31)D.=SUMIF(A:A,MONTH(F2),C:C)

Discussion 0

Join free to post in the discussion.

Monthly total from a date column

Discussion 0

Related questions