index / match now sum

[Calzor]

Hi,

First time poster long term lurker Wonder if someone can help me out?

I have a one to many relationship I need to add up.
On my first sheet I have the 'one', a server in field A with my formulae in field B
On my second sheet I have the 'many', the servers numerous disks in field C.

I now need to find all disks on the second sheet and then add up field C.

My simple formulae as below just finds the first match and reports the size [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=INDEX(vDisk!A:C,MATCH(A2,vDisk!A:A,0),3)[/FONT][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]
How do I expand this and get the sum of field C that match field A?


[/FONT]

 

[Fluff]

Hi & welcome to MrExcel.
Have a look at SumIf https://exceljet.net/excel-functions/excel-sumif-function

 

[Calzor]

Thanks, in the end this got really complicated when the requirement moved a bit...
After three new columns I finally got to the point I could use SUMIFS, thanks for the pointer

 

[Fluff]

Glad you sorted it & thanks for the feedback