Writing a Date Function

[thebside]

Ok, I am stuck trying to write a function to do the following, and it would be greatly appreciated if someone could help me.
I have two columns, one of data, and another of dates. I need to write a function that filters by dates, and counts the total number of items

For Example:
My data (column 1) has Members, Non_Members, and Other. My Dates (Column 2) have, well, dates.
I have a report sheet that I need to report the numbers. So in the report for each data type (Member, Non_Member, Other) I want to be able to use function (=blah(date I am filtering for less than or equal to)) and have it be able to count Column 1 and put how many returned in column 3 for that date range.

Please, this is huge for me and will save days of work.

Thanks,
Brian

[Dave Peterson]

You have one guess at your post in .misc.

thebside wrote:
>
> Ok, I am stuck trying to write a function to do the following, and it
> would be greatly appreciated if someone could help me.
> I have two columns, one of data, and another of dates. I need to write
> a function that filters by dates, and counts the total number of items
>
> For Example:
> My data (column 1) has Members, Non_Members, and Other. My Dates
> (Column 2) have, well, dates.
> I have a report sheet that I need to report the numbers. So in the
> report for each data type (Member, Non_Member, Other) I want to be able
> to use function (=blah(date I am filtering for less than or equal to))
> and have it be able to count Column 1 and put how many returned in
> column 3 for that date range.
>
> Please, this is huge for me and will save days of work.
>
> Thanks,
> Brian
>
> --
> thebside
> ------------------------------------------------------------------------
> thebside's Profile: http://www.excelforum.com/member.php...o&userid=22736
> View this thread: http://www.excelforum.com/showthread...hreadid=387508

--

Dave Peterson