SUMPRODUCT, Dual Condition, Expense Type Query

[heatwave]

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?

[teylyn]

Hello heatwave,

try this

=SUMPRODUCT((TEXT($B$3:$B$7,"MMM")=C$9)*($C$3:$C$7=$B10)*$D$3:$F$7)

cheers

[heatwave]

That fits the bill PERFECTLY! Thanks tevlyn for the lightning fast response :D