That is how my data looks. Basically I want to add a cell that will sum the values of B, if the name in A is also in C. Something like...Please Login or Register to view this content.
=SumIfs(b:b,a:a,{ANYTHING IN C})
I also need to be able to add more values to C and have them included automatically, but I don't think that would be a problem.
Thanks
Bookmarks