G
gimiv
I have 2 worksheets. One named Daily, one named weekly. The A columns o
both sheets have dates. Daily has every business day (includin
holidays) and weekly has every Friday(including holidays). The
columns contain volume that coorelates with the dates. What I woul
like to do is take the Average values between 2 Fridays and put the
into the weekly worksheet. I had success with the first week because
was only searching on one criteria, but when I tried to search betwee
dates, no luck. This is the formula that worked for the first cell:
{=AVERAGE(IF(Daily!$A$4:$A$604<=Weekly!A4,Daily!$B$4:$B$604))}
Here is the formula I attempted the DID NOT work in calculating th
daily average of one weeks voume.
{=AVERAGE(IF(AND(Daily!$A$4:$A$604<=Weekly!A5,Daily!$A$4:$A$604>Weekly!A4),Daily!$B$4:$B$604))}
Any ideas? FYI, I want to skip the blank cells(holidays) in m
calculations.
Thanks,
Gim
both sheets have dates. Daily has every business day (includin
holidays) and weekly has every Friday(including holidays). The
columns contain volume that coorelates with the dates. What I woul
like to do is take the Average values between 2 Fridays and put the
into the weekly worksheet. I had success with the first week because
was only searching on one criteria, but when I tried to search betwee
dates, no luck. This is the formula that worked for the first cell:
{=AVERAGE(IF(Daily!$A$4:$A$604<=Weekly!A4,Daily!$B$4:$B$604))}
Here is the formula I attempted the DID NOT work in calculating th
daily average of one weeks voume.
{=AVERAGE(IF(AND(Daily!$A$4:$A$604<=Weekly!A5,Daily!$A$4:$A$604>Weekly!A4),Daily!$B$4:$B$604))}
Any ideas? FYI, I want to skip the blank cells(holidays) in m
calculations.
Thanks,
Gim