Ok, I've searched for well over an hour and can not quite find what I need.
I have 2 columns, column A lists dates 1-jan-08 through 12-dec-08 and column B will have $ from individual transactions, other columns have associated info not relavent to my formula needs at the moment.
example
A B
1/2/08 $52.22
1/5/08 $33.14
1/7/08 $102.44
2/3/08 $12.00
3/31/08 $45.00
4/7/08 $454.00
what i want to do is to get a total based upon the month.
I have seen sumproduct formulas similar to:
=sumproduct(--(month(a:a)=1),b:b)
and others that use offsets and just can not seem to get these to work, either I get an error or a zero.
the output that i am looking for is:
A B
Jan $450.00
Feb $1200.75
Mar $685.00
etc
Ultimately, this formula would appear on a financial summary sheet showing income by month and expense by month
any help would be appreciated
Bookmarks