excel sumifs

id like to ask for help please, will it be possible to count instances separately? Please see example below. Please thank you <colgroup><col><col><col></colgroup><tbody> Duration Time Status 0:30:01 10/11/2019 13:00 Break 0:16:01 10/11/2019 20:00 Break 0:51:01 10/11/2019 21:00 Break...

Good Day sir, I am creating some formula to make my calculation easier. However i am stuck. :laugh: In the Sheet 3 (with yellow mark) i want cell K6 and K30 have same value with K18. I already have formula in there, but idk what else i need to add. This sheet is working on how many job that 1...

Good Day sir, I am creating some formula to make my calculation easier. However i am stuck. :laugh: In the Sheet 3 (with yellow mark) i want cell K6 and K30 have same value with K18. I already have formula in there, but idk what else i need to add. This sheet is working on how many job that 1...

Hi I am trying to create a SUMIFS formula that will SUM across a range On sheet Bank if their Description Equals the same as the Description Sheet 1 page, And the date on Bank Page falls between two ranges on Sheet 1. I came up with this but it just equals 0...

I hope you can help. I have a couple of formulas that are breaking due to N/A appearing in cells. I was wondering if these N/A could be accommodated in my formulas to still return a numerical result. In the picture below you can see that in Cell C21 there is 'N/A' and in S21 the is the error...

Good morning all! So I have a spreadsheet where I have to compare monthly hour and cycle updates to aircraft. I need to show how much of an increase occurs each month and to catch any decreases. I have had success using SUMIF for the hours updates, but not the cycles. It only displays the...

Hello All I have a table like such below and I am using the following formula =SUM(SUM(D17)-SUMIFS(E5:E22,A5:A22,A17,B5:B22,B17-N4)) to return the result. For this example I should return a -0.05 (0-0.05) N4 = 25 I hope I can explain this clearly If the value in the cell = Column D ie 0 or...