Summarising rows based on other columns

Hello!   I need to summarise one of my columns [Qty] based on the other columns in the table. If Tr and Type are blank, and if Date and Job No are the same, I need the Qty to sum and the populated...