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

Nov 11, 2022 in Others 138 views

## 1 answer to this question.

Try SUMIFS.

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

## Excel use SUMIF but with a multiplier before summation: x2, x3, x4, etc

The product of the sum and the ...READ MORE

## Using Excel Proper Function with exception | Excel

To accomplish this, you might need to ...READ MORE

## How to use Excel VLOOKUP function with words that begin with the letters AB

If you lookup "AB" in Excel, it ...READ MORE

## EXCEL - SUMIF for multiple sheets

If another range of cells in each ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE