name amount
Bart 10
Peter 5
Julia 7
Peter 4
Marc 6
Hi, I want total amount of Peter
i know I can do =index(B2:B8), match("Peter", A2:A8,0))
Can I do a formula, something like =Sum(index(B2:B8), match("Peter", A2:A8,0)))
so that the result is 9
Thanks
Bookmarks