Your image does not show the Column and Row locations for your data, so it is hard to give you a direct formula; however, if you lookup the SUMIF function in the help files, I think that it will do what you seek.hello i want a formula to calculate sum of repeated text
exemple when i put the text its search in table and find the repeated text and calculate the sum
like in the picture