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, 2022 in Others by Kithuzzz
• 38,000 points
561 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, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

Excel OFFSET function with a dynamic row argument

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

answered Sep 26, 2022 in Others by narikkadan
• 63,600 points
1,156 views
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, 2022 in Others by narikkadan
• 63,600 points
1,285 views
0 votes
1 answer

Using Excel Proper Function with exception | Excel

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

answered Oct 22, 2022 in Others by narikkadan
• 63,600 points
521 views
0 votes
1 answer
0 votes
0 answers

EXCEL - SUMIF for multiple sheets

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

Oct 31, 2022 in Others by Kithuzzz
• 38,000 points
571 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, 2022 in Others by Edureka
• 13,690 points
4,102 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, 2022 in Others by Edureka
• 13,690 points
2,009 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, 2022 in Others by Edureka
• 13,690 points
988 views
0 votes
1 answer

Excel concatenate function with multiple conditions

Use this : =TEXTJOIN(", ";TRUE;IF((Table69[Spec]=$B$1)*(Table69[Sl ...READ MORE

answered Dec 10, 2022 in Others by narikkadan
• 63,600 points
741 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, 2022 in Others by narikkadan
• 63,600 points
3,602 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