formula to calculate sum of repeated text

[tinkode]

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

 

[Rick Rothstein]

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

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.

 

[Fluff]

Something like
=SUMIF(A:A,D3,B:B)

Also please respond to the PM that I sent you.

 

[tinkode]

its not problem about the column i will change them

 

[Fluff]

Did you see post#3?

 

[tinkode]

thanks you fluff

 

[Fluff]

You're welcome