countif and sum

  1. M

    Formula for showing the age range when dates are given

    Hi, I'm trying to create a simple table that counts dates that fall into a specific age range: <tbody> 0-10 days old ? 10-20 days old ? Over 20 days old ? </tbody> The easiest way would be to add a column to where the dates are and insert the networkdays formula but I need to avoid and...
  2. B

    Counting using frequency formula with multiple criteria

    I have a financial modeling issue I can not solve. I am seeking: 1. The number of unique obligors with a senior debt principle value investments >0 2. The number of unique obligors with a principle value investment >0 <tbody> A,1 B C D What I expect the results to be: 2 Obligor...
  3. A

    Count total occurrence of time in a series of time ranges: Urgent Help Please?

    Hi, please i have three columns Data is arranged as follows Arrival Time Start Finish Count 13:23 14:24 19:50 13:23 14:24 19:50 13:24 13:05 17:20 13:25 12:12 22:22 : : : : 13:22 Column A has 1440 arrival times to represent 1440 minutes in...

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