Hi,
I am trying to add a formula that will find, Cell A1(sheet1) in sheet 2 column A
And then for it to count how many 'Perfect' for cell A1(same as above) are in Column G(on sheet2)
I have tried COUNTIF/ SUMPRODUCT/ LOOKUPS and it keeps adding the number of times Cell A1 shows up along with the number of Times "perfect" can be found.
Any help will be appricated
Thanks
Bookmarks