Help with sum of column
Posted by DMH on December 11, 2001 6:55 PM
I have three columns in a worksheet A=Date, B=Purchases of ItemB per Day and C=Purchases of ItemC per 7 Days. I have created a summary the lists the purchases of ItemB and ItemC for the last 7 days, last 30 days and last 90 days(counting bottom up). I was able to do this using the offset function, countA and named ranges for the daily data for ItemB. However, the weekly data for ItemC is giving me fits because I have 6 blank cells between each ItemC datapoint. I have tried using an IF ISNUMBER combo but my syntax and logic seems to have reached their limits.
Can someone suggest a direction. I am not comfortable with macros or vba if there is a function that will do.
Thanks a bunch!