Thanks to all for the help, I managed using the sumproduct function. I
will have a look at pivot tabled as well.