Here is the what the two columns look like
Date Profit
1/1/2006 1
2/2/2006 2
2/3/2006 3
4/4/2006 4
I want to get the sum of the profit only if the month is Feb by using the Month() function (return a number from 1-12, signifying a month)
Can I do that with a SumIf statement? if not, any good suggestions? (without creating another column)
Thanks in advance.
Date Profit
1/1/2006 1
2/2/2006 2
2/3/2006 3
4/4/2006 4
I want to get the sum of the profit only if the month is Feb by using the Month() function (return a number from 1-12, signifying a month)
Can I do that with a SumIf statement? if not, any good suggestions? (without creating another column)
Thanks in advance.