Hi there,
I am trying to use an array to calculate the product of entries called RoR that correspond to the each month of a year. Col C is dd/mm/yyyy, Col D is RoR and I have define Col B to be text(col C,"mmm-yy"). in a different cell i have entered the month whose corresponding RoR I want to have the product off. Although it seems pretty straightfwd I am somewhere getting stuck and I sense it is an easy fix. I am including the spreadsheet for better clarity and I appct any pointers. The calculation is happening in cells h5:h17
Thnx
Bookmarks