date formulas in excel

November 22, 2011 at 05:40:22
Specs: Windows XP
i have a spreadsheet with different dates in the same column. How can do add sum of each month pertaining to the dates

See More: date formulas in excel

Report •

November 22, 2011 at 09:43:28
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 1 pertaining to January:

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

as will this non-array formula:


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

Report •
Related Solutions

Ask Question