Hi All,
I have an excel sheet in which I have 3 columns, Column A is giving me a week number from date entered in Column B. Column A is a merged Cell.
There are values in Column C.
I want to be able to sum cells of column C ( not entire Column, select few cells) who show 1 (representing Week number) against them in Column A. I have been trying to sort this out since Thursday and have had no success.
Please see attached example , Any help will be greatly appreciated.
Salman
Bookmarks