i have a spreadsheet with different dates in the same column. How can do add sum of each month pertaining to the dates

What do you mean by "sum of each month pertaining to the dates"? Do you have another column of values that you are trying to sum based on which month those values correspond to?

If so, this Array formula should do it, with the

1pertaining to January:=SUM(IF(MONTH(A1:A5)=1,B1:B5,0)) Entered via Ctrl-Shift-Enter

as will this non-array formula:

=SUMPRODUCT((MONTH(A1:A5)=1)*(B1:B5))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think Marissa Mayer deserves a large severance payout from Yahoo!?

Discuss in The Lounge

Poll History