I need to come up with a formula in excel with 2 criterion. Here's a simplified description of the worksheet:
Column A - Date
Column B - Transaction Code
Column C - Amount
What I'm looking for is the sum of all transactions in a certain date where the transaction code starts with a specific number.
Any ideas?
Thank you VERY much in advance to anyone who can help.
Bookmarks