Excel sumif function with conditions

Question

I am having problems creating a column with a lot of variables that I need to total. (For a reference, see the image)

If G (Sum Time) is less than 300 (300), if B (Type) = 1, if D (Date) is an input cell, and if E (Time) is a specific range that I can adjust, for example, "7 pm -12 pm," then I need to add those values together.

This is what I have attempted thus far despite not having much experience with these situations.

sumif(Table1[[ type]]=1, IF(Table1[[#All],[Date]]=K3, AND(Table1[[#All],[Time]]=K4, IF(Table1[[#All],[Sum Time (sec)]]=<300))))

Any help would be greatly appreciated

Picture here : 

Answer 1

Try SUMIFS.

=sumifs(table1[sum time (sec)],Table1[type],1, Table1[Date],K3, Table1[Time],K4, Table1[Sum Time (sec)],"<300")