Nth cell in a row being summed

[mrsmunk]

I have
Jun Medical - Jun RX - Jun Vision - Jul Medical - Jul RX - Jul Vision
$120 10 30 120 20 35
I need to add all Medical
then all RX
Then all vison

 

[MrKowz]

Give this a go:

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	Jun Medical	Jun RX	Jun Vision	Jul Medical	Jul RX	Jul Vision		Medical	240
2	$120	10	30	120	20	35		RX	30
3								Vision	65
Sheet1

Excel 2003

Cell Formulas
Range	Formula
I1	=SUMPRODUCT(--(ISNUMBER(SEARCH(H1,$A$1:$F$1))),$A$2:$F$2)

 

[mrsmunk]

I tried this and I am getting a #VALUE!
=SUMPRODUCT(--(ISNUMBER(SEARCH(AL7,B7:AK7))),$A$44:$AK$44)

 

[MrKowz]

Your range dimensions aren't identical:

SUMPRODUCT(--(ISNUMBER(SEARCH(AL7,A7:AK7))),$A$44:$AK$44)

 

[mrsmunk]

oops - sorry about that. It worked
Thanks!!

 

[bosco_yip]

Or, this simplier formula :

=SUMIF(A$7:A$K7,"*"&AL7,A$44:AK$44)

Regards