Match multiple criteria in different lines

Hi;

Someday I hope I will be able to wrap my head around the match concept but for now I hope the forum comes to my rescue once again. I need to match sales and customer counts based on the terminal name and date. The two sections will eventually be on separate tabs in the same workbook. I have attached a sample sheet.

If you want to keep things simple(r) you need only add a 'key' ... so, using your sample file:

G3: =LOOKUP(REPT("Z",255),$B$3:$B3)&"^"&$C3
copied down

N3: =SUMIF($G:$G,$M3&"^"&N$2,INDEX($D:$E,0,1+(N$1="Head Count")))
applied to matrix N3:AA16