help me in coding for sumif formula

Hi,

Please find the attached template and help me with the coding where i can use sumif condition.

Regards,
Vimala K

Maybe:

Sub vimalanathkx()
Dim i As Long, x As Range, ws As Worksheet, ws2 As Worksheet, y As Long, z
Set ws = Sheets("Basic")
Set ws2 = Sheets("Master")
With ws2
ReDim z(2 To ws2.Range("L" & Rows.Count).End(3).row)
    For i = LBound(z) To UBound(z)
        Set x = ws.Rows(1).Find(.Cells(i, "L"), LookIn:=xlValues, lookat:=xlWhole)
            If Not x Is Nothing Then
                y = ws.Cells(Rows.Count, x.Column).End(3).row
                .Cells(i, "D").Formula = "=SUM(" & "Basic!" & ws.Range(ws.Cells(2, x.Column), ws.Cells(y, x.Column)).Address & ")"
            End If
        Set x = Nothing
    Next i
End With
End Sub

Hi John....

Its awesome and working fine.....

But i have multiple sheets in my original template which needs to be consolidate to the master sheet... sorry i didnt give this at the first instance... CC and order is common in all the sheets so in the column P if the Basic word is finished it should go to the next sheet based on the next text which is Conveyance.

please find the attached template for your reference.