if i have the excel file include 6 sheet and i coulm A:A the name of products


how i can count all cell which include spesfic products for example in sheet
one 5 cell include the products a and sheet 2 100 cell have product a so the
total will be 105 also if i have more than one file with more than one sheet
how i can count ot