I have a spreadsheet which totals prize money in our village flower show.
Is it possible please to do a function which looks back along a row and counts up how many people got a score of exactly 100?
Any ideas gratefully received!
Also count how many 100 scores along a row any one person got (ignoring lower scores).
Thank you.