Extend my =sumproduct formula

[Bandito1]

Hello all,

I got this formula that counts all values that has the word "expenses" in column E.

=SUMPRODUCT(--('Vermogen data'!C:C=Q12);--('Vermogen data'!E:E="Expenses");('Vermogen data'!B:B))

Now i would that this formula counts all values that word "expenses" and "beleggen".
So the 2 values in column E.

How do i add this extra variable to my formula?

 

[RoryA]

I'd use SUMIFS with an array and SUM:

=SUM(SUMIFS('Vermogen data'!B:B;'Vermogen data'!C:C;Q12;'Vermogen data'!E:E;{"Expenses";"beleggen"}))

 

[Bandito1]

That works, thank you very much