vzachin
01-24-2012, 07:40 PM
hi,
i need help with 2 formulaes based on date ranges.
column a contains my dates; column b are the widget types and column c is the count of the widget type.
i need a monthly summary of the data in columns g,h,i and k,l,m.
can i use sumproduct to accomplish this? or is it easier to do the calculation with vba?
thanks
za
i need help with 2 formulaes based on date ranges.
column a contains my dates; column b are the widget types and column c is the count of the widget type.
i need a monthly summary of the data in columns g,h,i and k,l,m.
can i use sumproduct to accomplish this? or is it easier to do the calculation with vba?
thanks
za