A B 1 Date Data 2 1/1/2014 1 3 1/2/2014 2 4 3/5/2014 3
I wanted to sum up rows for certain months. With
month I can get the month and
sumif lets me to sum rows that only meet the criteria. However since I don't know how to get the value of the cell and pass it to
month I have to create a new column just for the month. And now the formula looks like:
I don't want to specify a column just for the month. Is there a way I can get the value of the cell and pass it to
month for comparison (without using a new column)?