Hi all,
I have a partially solved Excel problem. All the details and queries are as per attached example.xls.
The data comes in the following columns:
* Date (dd-mmm)
* Expense Type
* 3 different accounts where the expenses can be charged to
The idea is to be able to sum a specific expense type for a particular month.
I solved the problem provided the specific expense type is paid with a specific account. However reality is quite different - the expense type can be paid with any of the 3 available accounts.
How can the formula be modified to search all 3 accounts?![]()
Bookmarks