Search for range for sumif

[Malinga]

This is a complicated SUMIF that I am struggling with,
I am trying to search for the term "TOTAL" in a worksheet (e.g. E14, E25, E36, E41 all have TOTAL), that will then give me the addresses of all these cells as a range for another formula within the same cell.
Using this range, I then want to add up the cells adjacent to the right of these addresses (e.g. F14, F25, F36, F41)

Thanks in advance,

 

[Domenic]

Try...

=SUMIF(E14:E41,"Total",F14:F41)

Or, if the word "Total" occurs within a text string, try...

=SUMIF(E14:E41,"Total*",F14:F41)

 

[taigovinda]

Welcome to the board!

Is this different than:

=sumif(e14:e41,"TOTAL",f14:f41)

?

 

[Malinga]

Thanks guys, hadn't realised it was so simple, thanks for your help