Thanks so much Ron.You've helped greatly..Hoping to learn some more.I also
tried the sumproduct function.Got the results i was hoping for..and am
referring to that sheet containing the values i need.Trying to sum it up in a
report..coz i have to present it....if you have any ideas how i can present
reports in excel in a presentable method..i would appreciate it more.

Have a nice day