Forum

Thanks Mynda. I know it has to be a number. But if we put a reference number which links to the names of the plans and consumption pattern it works. I...

My apologies. I should have been more specific. I have built 2 single variable data table - for a selected scenario, what is the average monthly cost ...

Thank you so so much. Worked like a charm! I complicated it in my head. I need to build scenarios for different plans and consumption scenarios. W...

Thanks I know. I tried using sumproduct function with indirect and weekday but I cannot get it right. Somehow I need to link the month and year - ...

Forgot to mention I cannot use pivot tables or vba for this.