group data according to month/year

[Mosaddeq Aziz]

hi,

i have two columns of data. one column has date in that and the other has
value in it. I like to group them according to month/year and find the
subtotal of each month in one year. I like to accomplish it without using
pivot table. is that possible?

Mosaddeq

 

[Dave Peterson]

You could add a helper column with a formula like:
=text(a2,"yyyymm")
and then sort your data by this column.

Then apply subtotals to the range using that helper column as the key.