Double Lookup - Possibly SumIfs

[1Stacy]

Hi Everyone,
I am trying to display some specific information from a worksheet onto a front page of the workbook (currently Sheet 1).
From the Budget Entry tab (where all of the needed information is stored) i would like to display if the Site (A) = (Budget Entry column B) and the cost type (B,C, or D) = (Budget Entry I), then sum (Budget Entry S) in the corresponding cell for example: (B3) (C4)

Workbook attached - all site name and costs...are fictitious.

Thanks for your help.

i've tried in B3 SUMIF((BudgetEntry 1718!$S$, BudgetEntry$B, SHeet1A3) (Budget Entry!I, Sheet1B2))

[tim201110]

=IF(VLOOKUP($A3,'Budget Entry 17 18'!$B$2:$I$7,8,)=B$2,VLOOKUP($A3,'Budget Entry 17 18'!$B$2:$I$7,2,),"")

[1Stacy]

Thanks but I couldn't get it to work - I am trying to sum column S of Budget Entry - if it matches the Site in column A (Sheet1) and the type in Row 2 (Sheet1)

[1Stacy]

I used a sumifs in the end it looked like this:
=SUMIFS('Budget Entry 17 18'!S:S,'Budget Entry 17 18'!B:B,'Infrastructure Breakdown'!A2,'Budget Entry 17 18'!I:I,'Infrastructure Breakdown'!$B$1)

In case that helps anyone else out.
Thanks Forum!