sumifs date

  1. M

    SUMIFS with multiple Criteria

    I'm trying to sum data based on a phone time for a person between two dates. I'm returning a blank value in the cell currently and can't figure out why. I've watched multiple videos to find a solution and i must be missing something. Formula...
    • mmode66
    • Thread
    • iferror multiple sumifs date sumifs multiple criteria videos
    • Replies: 2
    • Forum: Excel Questions
  2. L

    SUMIFS - Account Type and Date

    I am trying to have a rolling sum to calculate based on the account type and include today and previous dates - I cannot get the SUMIFS function right (or if this is even possible): =SUMIFS(E:E,F:F,"8948",A:A,">=Today()") <style type="text/css"><!--td {border: 1px solid #ccc;}br...
    • LoriSeely
    • Thread
    • balance date sumifs conditional sumifs date sumifs formula
    • Replies: 5
    • Forum: Excel Questions
  3. M

    Not sure which Excel Formula is needed.

    In my workbook, I have 7 tabs. Tab 1 is a Summary of the next 5 tabs, Tab 7 is just dates. All my data is stored in a separate workbook. I have all the data being auto populated on tabs 2-6 without issue. These tabs are a "Sunday to Saturday" look based on the date chosen in a certain cell. On...
  4. G

    SUMIFS with a date

    Hello, I have a formula - SUMIFS('Summary 2016'!$E:$E,'Summary 2016'!$B:$B,CONCATENATE(L4," ",M$3)) which works perfectly well but when I try and add a date criteria I get an error message or zero. e.g. =SUMIFS('Summary 2016'!$E:$E,'Summary 2016'!$B:$B,CONCATENATE(L4," ",M$3),'Summary...

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
Back
Top