Excel sumif function with conditions

0 votes

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 : https://i.stack.imgur.com/XtqjE.png

Nov 11 in Others by Kithuzzz
• 20,660 points
42 views

1 answer to this question.

0 votes

Try SUMIFS.

=sumifs(table1[sum time (sec)],Table1[type],1, Table1[Date],K3, Table1[Time],K4, Table1[Sum Time (sec)],"<300")
answered Nov 11 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

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

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

answered Sep 30 in Others by narikkadan
• 37,660 points
56 views
0 votes
1 answer

Using Excel Proper Function with exception | Excel

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

answered Oct 22 in Others by narikkadan
• 37,660 points
34 views
0 votes
1 answer
0 votes
1 answer

how to show the <meta> values of yoast seo with some function?

check this folder : wordpress-seo\src\presenters\open-graph you can ...READ MORE

answered Feb 10 in Others by narikkadan
• 37,660 points
127 views
0 votes
0 answers

EXCEL - SUMIF for multiple sheets

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

Oct 31 in Others by Kithuzzz
• 20,660 points
40 views
0 votes
1 answer

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

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
142 views
0 votes
1 answer

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

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

answered Feb 16 in Others by Edureka
• 13,640 points
240 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

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

Feb 17 in Others by Edureka
• 13,640 points
109 views
0 votes
1 answer

IF function in combination with an Round function Excel

I'm not sure if it is a ...READ MORE

answered Sep 25 in Others by narikkadan
• 37,660 points
59 views
0 votes
1 answer

Excel OFFSET function with a dynamic row argument

The answer is to make "anchor cells" ...READ MORE

answered Sep 26 in Others by narikkadan
• 37,660 points
77 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP