Add 2 cell results together

[Dom.Knight]

Hello,

On my attachment i have a set of data ive entered on sheet 1.

In sheet 2 and 3 i wish to perform searches either based by boat or merchant. (Located A2)

On Sheet 1 Column F I have boxes and in Column G I have the part. On sheet 2 I wish to have the 2 added together to provide the answer.

Attachment shows expected results in Red

[Sadath31]

Hi

formula in A7 (sheet2)
=IFERROR(INDEX(Sheet1!$A$1:$I$1000,AGGREGATE(15,6,ROW(Sheet1!$A$1:$A$1000)/(Sheet1!$A$1:$A$1000=$A$2),ROW()-6),COLUMN()+1),"")

copy down and right