hi
i have a sheet with 4 columns. the cells in those columns gets populated with numbers. as well as a column for a persons name. on a different sheet i wish to calculate each column based on a specific criteria(person name).
so say my column names are A1 = apples, B1 = oranges, etc and i have a count of how many of each is sold by a specific salesman, when i select the salesman on a seperate sheet i wish to look through those 4 columns and match the salesman with the item then count how many of the items was sold. hope that makes sense.