# sum by date

1. ### 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. ### 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. ### 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. ### 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...

### 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.

### Which adblocker are you using?

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

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