sumproduct + count days

  1. B

    EXCEL DATE - If Series Contains Date, the Count!

    First off, thank you for your help and taking the time to read this. Here is the situation I am trying to solve: I have two date/time stamps per transport unique identifier, I am trying to write a formula that says if on a given date, how many active transports occurred that were not...
  2. T

    Sumif, index, match on multiple criteria

    I need to calculate a gross sum of Rating for date wise ad placement, rating will be on next sheet for all days; ie monday, tuesday, wednesday and so on... table of ads placement will be on another sheet which will consist of dates, frm rating sheet look and match the 'day' & 'timeslot' then...
    • tabkaz
    • Thread
    • index match subtotal sumif sumproduct + count days
    • Replies: 0
    • Forum: Excel Questions
  3. M

    Sumproduct for date counting

    After some research I have found a solution for counting date occurrences within a cell range. Could someone give me a breakdown of the following function and a reasonably simple explanation of how it works. =SUMPRODUCT(--(TEXT(A1:A100,"mmmyyyy")="Jan2000")) Thank you
    • madstock
    • Thread
    • count explainations sumproduct sumproduct + count days
    • Replies: 4
    • Forum: Excel Questions
  4. H

    Counting Cells with ColorFunction per month

    Hi Have a sheet that counts the total number of cells in a column with specific colours =ColorFunction(Closed!$B$1,Closed!$G$7:$G$9071,FALSE) Each Cell has a date in it. I am able to count the total number of cells in used in any month by the date entered...
  5. S

    Sumproduct - count dates with date range

    Hi Guys, New - Stuck and hope someone can help me .. I have a date range which i want to check if it falls within another date range and if it does count how many day in the first date range fall withing the second date range I Want to check if this date range (1) C6 : 28/08/10 C7 ...

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