Alternative to this =SUMIFS?

[MOB]

I am trying to use this formula;

=SUMIFS('Income by Home'!D4:O27,'Income by Home'!B4:B27,'P&L'!$B$2)

Where;

D4:O27 is financial data by month
B4:B27 is a list of Home names
B2 is a dropdown of the Home names

I can see that D:O is the issue as D:D returns the first column Value - but I want 12 months sum rather than one?


TIA

 

[RoryA]

You need SUMPRODUCT:

=SUMPRODUCT('Income by Home'!D4:O27*('Income by Home'!B4:B27='P&L'!$B$2))

 

[MOB]

Awesome once again! Many thanks