Count Cellls with Specific Text and Return the Summ of the Associated Values from Another Cell

[SiuGuy007]

I have this spread and trying to find the correct way of count the number of cells (horizontally) that contain a specific text and add that value to an open cell. Then for the cells that have the specific text, I need to sum the values found in another cell range and all the aggregated summed total to a new cell.
A B C D E H I J K ...................
[TABLE="width: 661"]
<colgroup><col><col span="4"><col><col><col span="3"></colgroup><tbody>[TR]
[TD] 1 File
[/TD]
[TD] FI
[/TD]
[TD][/TD]
[TD]Type[/TD]
[TD][/TD]
[TD][/TD]
[TD]Case[/TD]
[TD]FI[/TD]
[TD][/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]2 34274M
[/TD]
[TD="colspan: 2"] Diane Maly
[/TD]
[TD]Locus[/TD]
[TD][/TD]
[TD][/TD]
[TD]34272W
[/TD]
[TD="colspan: 2"]John Adberg
[/TD]
[TD]Statement[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]$25.00[/TD]
[TD][/TD]
[TD]$70.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]$28.00[/TD]
[TD][/TD]
[TD]$70.00[/TD]
[/TR]
[TR]
[TD]4 4.70
[/TD]
[TD]Hours - F
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]7.25[/TD]
[TD]Hours - FI[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Counting across row 2 the specific text would be "statement" found in K2 or any other cells in row 2. For the number of Statements found the count would be added to cell B50. Than for the cells that had "statement" I need the sum of the values found in row 4 (in this example it would be H4) added to cell B51.

A B
50
51

Any help would be greatly appreciated.

SiuGuy

 

[jtakw]

Hi,

Is this what you mean?

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K
1		File	FI		Type			Case	FI		Type
2		34274M	Diane Maly		Locus			34272W	John Adberg		Statement
3			$25.00		$70.00				$28.00		$70.00
4		4.7	Hours - F					7.25	Hours - FI
5
49
50		1
51		70
Sheet1

Cell Formulas
Range	Formula
B50	=COUNTIF(A2:K2,"Statement")
B51	=SUMIF(A2:K2,"Statement",A3:K3)

 

[SiuGuy007]

jtakw

Yes this works,,,,,,,Thanks for your prompt response.

SiuGuy

 

[jtakw]

You're welcome.