Totaling across a range based on text string

[HavocManiac]

Not an excel guru at all but what I'm looking to do is search a column for a text string and if it finds it run a total sum based on the value to the left. I'm looking to do this across two sheets and look for the same text string and same column. Any help? Thanks up front!!

 

[AkaTrouble]

you could use something like this to allow you to add two searches together


on sheet 1

[TABLE="width: 315"]
<tbody>[TR]
[TD][TABLE="width: 315"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD]cat[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD]dog[/TD]
[TD="align: right"]160[/TD]
[TD]< formula<formula<formula< td=""></formula<formula<>
[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD]cat[/TD]
[TD]cat[/TD]
[TD]<< search term[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD]cat[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD]dog[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD]cat[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD]dog[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
on sheet 2

[TABLE="width: 128"]
<tbody>[TR]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]20[/TD]
[TD="class: xl65"]cat[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]20[/TD]
[TD="class: xl65"]dog[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]20[/TD]
[TD="class: xl65"]cat[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]20[/TD]
[TD="class: xl65"]cat[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]20[/TD]
[TD="class: xl65"]dog[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]20[/TD]
[TD="class: xl65"]cat[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]20[/TD]
[TD="class: xl65"]dog[/TD]
[/TR]
</tbody>[/TABLE]

=(SUMIF(B2:B9,C4,A3:A9)) + (SUMIF(Sheet2!B2:B9,C4,Sheet2!A2:A9))