Count cells with a specific time stamp

[Randomhero180]

Hey All

here is the formula I am currently using:

=SUMPRODUCT((Sheet1!B19:E15235="Contact Sheet Available/Disc Sent")*(MONTH(Sheet1!H19:H15235)=MONTH(TODAY())))

This counts all entries with the status "Contact Sheet Available/Disc Sent" and that have a timestamp within the current month.

I need to alter this to count the last week in september and the first 3 weeks in october (using this month as an example and will have to have to be able to run without changing dates next month)

Any ideas?

Thanks in advance.

RH

 

[jbeaucaire]

The question seems choatic. Don't you mean,

"How do count all rows within a 4-week period based on a starting date I can indicate?"

 

[Randomhero180]

Trust me I know it sounds chaotic haha.

How about this...

How about a way that I can input two dates in the formula ie: 9/26/11 and 10/21/11

and count the number of cells that have the status "Contact Sheet Available/Disc Sent"

Again this is what I have now

=SUMPRODUCT((Sheet1!B19:E15235="Contact Sheet Available/Disc Sent")*(MONTH(Sheet1!H19:H15235)=MONTH(TODAY())))

 

[T. Valko]

Trust me I know it sounds chaotic haha.

How about this...

How about a way that I can input two dates in the formula ie: 9/26/11 and 10/21/11

and count the number of cells that have the status "Contact Sheet Available/Disc Sent"

Again this is what I have now

=SUMPRODUCT((Sheet1!B19:E15235="Contact Sheet Available/Disc Sent")*(MONTH(Sheet1!H19:H15235)=MONTH(TODAY())))

Use cells to hold the date criteria:

• A1 = 9/26/2011
• B1 = 10/21/2011

Then:

=SUMPRODUCT((Sheet1!B19:E15235="Contact Sheet Available/Disc Sent")*(Sheet1!H19:H15235>=A1)*(Sheet1!H19:H15235<=B1))