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 :