excel sumifs

  1. S

    Sumif instances separately with Date idetifier

    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...
  2. L

    Help me with Sumifs, Index and Match

    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...
  3. L

    Please Help me to SUM

    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...
  4. B

    SUMIFS Using ranges in the criterion

    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...
  5. C

    IF Statements with AND and N/A calculations

    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...
  6. S

    SUMIF only works for 1 column and not the other?

    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...
  7. P

    Excel Formula

    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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top