Ref. attachment forumhelp.xlsx
1. Sumproduct
In column C, i am trying to get total of corresponding G cell values in accordance with A column.
ie, A column has some unique numbers.
2. H column has some formula (by indexing / matching A column) to get entries from sheet bank. It works fine.
But brings 0 result in empty columns. It should be blank.
Please help.
Bookmarks