Have a large spreadsheet with 1 column I want to monitor changes in on a
monthly basis. (In a separate sheet, i setup TRACK report to monitor monthly
changes for this one column)

This column is now empty. If I added data into 5 of the rows in jan, and 6
different rows in Feb, I want the TRACK report to reflect how many entrys for
jan and how many for feb.

Is there a function or do i build a macro?

Assuming data entered in Sheet1 in A1 down, with the dates of entry input
into B1 down (these are assumed real dates)

In TRACK,
Put this in any cell, eg in B2:
=SUMPRODUCT((MONTH(Sheet1!$B$1:$B$100)=ROWS($1:1)) *(Sheet1!$B$1:$B$100<""))
B2 returns the count for January. Copy B2 down to B13 to return the counts
for all 12 months.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Francis" wrote:
Have a large spreadsheet with 1 column I want to monitor changes in on a
monthly basis. (In a separate sheet, i setup TRACK report to monitor monthly
changes for this one column)

This column is now empty. If I added data into 5 of the rows in jan, and 6
different rows in Feb, I want the TRACK report to reflect how many entrys for
jan and how many for feb.

Is there a function or do i build a macro?

This works, thank you.

"Max" wrote:

Assuming data entered in Sheet1 in A1 down, with the dates of entry input
into B1 down (these are assumed real dates)

In TRACK,
Put this in any cell, eg in B2:
=SUMPRODUCT((MONTH(Sheet1!$B$1:$B$100)=ROWS($1:1)) *(Sheet1!$B$1:$B$100<""))
B2 returns the count for January. Copy B2 down to B13 to return the counts
for all 12 months.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Francis" wrote:
Have a large spreadsheet with 1 column I want to monitor changes in on a
monthly basis. (In a separate sheet, i setup TRACK report to monitor monthly
changes for this one column)

This column is now empty. If I added data into 5 of the rows in jan, and 6
different rows in Feb, I want the TRACK report to reflect how many entrys for
jan and how many for feb.

Is there a function or do i build a macro?

welcome, Francis.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Francis" wrote in message
...
This works, thank you.