I have a transaction register (over 300 rows) from my bank for 2010 which I want to analyze and these are these columns:
Date,Trans type,Check#,Desription,Amount
The description column is free-form but for each like transaction (condo bill, electricity, cable), there is a common string within that can be found (I used the search function).
I'm focusing on the DSUM function but please offer any better suggestions. In the DSUM criteria range I need to include a function which tests for say 'UHG OVATIONS being contained in the Description cell but I can't figure out how to do it.
How do I do this,
Thanks in advance.
Bookmarks