Sum if certain criteria is met
I have a column with dates in it (Jan-12-2004) I have another column with the
transaction price in it like $21.95.
I need to sum the column by month. I can do mid(Jan-12-2004,1,3) to take out
the info except Jan but then how do you sum from that point on.
|