Kaizer
03-12-2006, 09:38 AM
In sheet "Stock" I have a little DBase that has names e.g. Regions, Countries, Accounts and Amounts by months (Jan to Dec) and by quarter (Q1 to Q4). On the "Report" sheet I have a drop-down list with periods (e.g. Jan, Feb,...Q1,...Q4) and countries/accounts. I need to create a function that would calculate an Array formula Depending on selected period. This function should take Period, County and Account as its arguments.
I was trying to make an If... formula but it gets very long. I thought function should make the job better. Can you help with the code for this function?
I attach a little file to my post for you to be able to see how the the report and DBase are structured.
Thank you in advance.
I was trying to make an If... formula but it gets very long. I thought function should make the job better. Can you help with the code for this function?
I attach a little file to my post for you to be able to see how the the report and DBase are structured.
Thank you in advance.