2/1/2017

  1. T

    Count Unique with on multiple If

    I need a unique count of users within each week. Sample Data: <tbody> Date Name Week Number Sum of Unique Count of users each week (Need Formula for this one) Expected RESULT 2/1/2017 Donald 5 3 2/1/2017 Goofy 5 3 2/1/2017 Minnie 5 3 2/2/2017 Donald 5 3 2/2/2017 Minnie 5 3...
  2. korhan

    Complex sumifs formula with multiple criteria

    Hi everyone, I am trying to implement a count formula using sumifs but I couldn't wrap my head around it. I want to be able to count member depending on the code column. Anything less than or equal 3. Also, date will be another criteria. Trickiest part is amount will be a criteria for counting...
  3. B

    Count Values in A Range of Dates

    Good morning All Actually viewed this subject in a recent Post. Attempting to understand why the Int Function returns a value error from a cell. I believe it has something to do with the dates not in English format. The cells with the error are from 16/01/2017 11:30 and down. <tbody> Thanks...
  4. M

    average only if month is over

    Hi I have data that is complied by month however I would like to only average the months that are over. Fore example 8/1/2017 has not passed and I do not have full data for it so I would like it excluded from the average. thanks a lot in advance for any help!!! 1/1/2017 13.61 % 2/1/2017...

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