On the attached example i would like a formula in F2 which sums all the values where column equals "Smith" and column B equals "Golf European".
I'm assuming it would involve the SumIf formula but i'm not sure if this is the best solution when the criteria is in two columns?
Thanks,
Adam.
Bookmarks