Lookup and Counting Data based on Month

[wheatgrass]

Trying to figure out the following:

If worksheet Client Files column Y is within date range of cells B1 & D1 of worksheet Matt's Mthly Report, then average number of days in worksheet Client Files column AH and place answer in cell 4F of worksheet Matt's Mthly Report.

Thanks

[DonkeyOte]

If as implied you wish to calculate a month:

Please Login or Register  to view this content.

If not always a complete month:

Please Login or Register  to view this content.

Those using XL2007 and beyond would use AVERAGEIFS function.

[wheatgrass]

I tried but not sure where to put the code on the workbook to make this work. Also, have 2007 version so would use Averageifs function. Would want to calculate the entire month. Can you help? Thanks.

[DonkeyOte]

...not sure where to put the code on the workbook to make this work.

In your initial post you stipulated:

...answer in cell 4F of worksheet Matt's Mthly Report

that is where the formula (not code) should be placed.

Also, have 2007 version so would use Averageifs function. Would want to calculate the entire month.

Please Login or Register  to view this content.

the above would be a replacement of the Array suggestion(s) provided previously and should be used in preference to

[wheatgrass]

thanks for your help.