Dear All,
Pls ref the attched excel. i have furits and its color entered in a row in sheet1, in sheet2, i have fruits as the column heading and colurs in the row. i need the total of each color... and if it zero , can we avoid displaying the zeros
ref attached sheet with example and extected result
Bookmarks