Quote Originally Posted by benishiryo View Post
welcome to the forum. assuming F2 has the Table number, maybe:
=SUMIF(C:C,F2,B:B)

but in future, do upload an excel sample so that we do not have to manually key in your data to do a testing.

input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand.

the upload attachment must be done by going to Go Advanced. click on Manage Attachments. Choose file, upload and close the window.

hopefully, i did a correct guess. otherwise, i have wasted time coming up with something that does not help you. if i really guessed it wrongly, please upload something according to my recommendations. try to use the solution i have given and we'll help to advise what went wrong.
Hi, this formula is exactly what I want. thanks a lot