I'm looking for an EXCEL FORMULA that can sum the # of items related to a certain row, if found, in the TABLE.
See the attached workbook for examples.
Sheet1 - My rawdata population
Sheet2 - My expected results (based off 'SITE' & 'Manager Level 5' columns
Need to count the # of times 'Finding' is in the specified row (in columns H through AA)
This is the usual format of the data I will be using.
Thank you for your assistance.