Sumifs & Match

[EmmaTM]

Hi,

I think I might need a sumifs and match option here, please can someone advise?

I want to complete this table, B14 contains a dropdown of dates which I want the blue cells to change depending on whats been selected in B14.

Here is the sheet with the data - the dates for B14 are along row 9 and depending on what date selected the total number of hours in rows 86-88 should pull through onto the table above:

Thank you

 

[Cubist]

Try:

=SUM(FILTER($H$86:$R$88,$H$9:$R$9=B14))

 

[Alex Blakenburg]

I don't know how representative your data is. If you only have each placement once in your data sheet you could use a 2D lookup instead of a SumIfs.
Since you asked for SumIfs you could try this.

20240503 SumIfs maybe EmmaTM.xlsx
	B	C
9	Placements	Hrs
10	A	86
11	B	87
12	C	88
13
14	14/04/2024
Sheet1

Cell Formulas
Range	Formula
C10:C12	C10	=SUMIFS(INDEX(Sheet2!$H$86:$R$88,0,MATCH($B$14,Sheet2!$H$9:$R$9,0)),Sheet2!$G$86:$G$88,$B10)

 

[EmmaTM]

Thank you Cubist & Alex for answering