sum by date

  1. C

    Counting dates in filtered row

    Hi all, I'm trying to count the number of cells that contain a date in a filtered row. I've been using the following formula, but it keeps coming back with a value of 0, even though there are 3 in the filtered row; =SUMPRODUCT(--('Fixture Status'!J3:J1000=">=0"),SUBTOTAL(3,OFFSET('Fixture...
  2. M

    Getting the sum of column based on equal dates

    Hello everybody. Monthly, I am making a report wherein I need to get the sum of a column based on specific dates. Attached is extracted sample of the data: A B C 1 Value Date Amount Sub Total 2 01/04/2012 89,812.10 3...
  3. P

    Counting quantities for a given week

    In cells A4:A250 i have dates entered A4=1/2/09 A5=1/2/09 A6=1/14/09 A7=1/15/09 A8=1/3/09 A9=1/10/09 A10=1/16/09 A11=1/19/09 A12=1/21/09 Dates are entered all the way through to A250 in no particular order but only for that month. In this example January and no dates for Sunday. D4=Yes D5=Yes...
  4. lgerick

    need help with macro or formula that will sum cells on the 1st day of the month

    Hello, I'm trying to write a macro or formula that will sum the following =(D2+B3)-C3 on the first day of the month. I need this for each month. Each month will change, so for October 1 2008 I need it to sum =237+B2-C2 November 1 2008 I need it to sum =(D2+B3)-C3 December 1 2008 I need it to...

Watch MrExcel Video

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