Another SUMIF with Lookup question

[RaoulF]

I have been struggling for a while over a formula that sums the contents of the cells in a table which have rows headed = "Net"&"*"&"Debt" [Where * may be "Senior" or "Mezzanine"] and where the column is the column headed by a date (as selected by the user in another cell).

I have been playing around with sumifs (but struggling to get it to 'lookup' the rows that I'm interested in). I also tried to use an index/match to return the sum_range but I just got a #REF. I wonder if I need a D-type formula or an array, but I'm not too hot on them??

Perhaps I'm just being brain dead at this time on a Friday pm, but any help on this would be apreciated.

Apologies if this has already been dealt with, but I can't find the answer on the board

 

[RaoulF]

Dave

I just found that my problem with the sumproduct seems to be that I had a blank row under the headers in row 1!! Not sure why that made a difference, or how it works with non-identical arrays, but you've got it.

Thanks for your perseverence

 

[Dave Patton]

Each of the suggestions that I made work in
a test ss.