Hi Ron,

Thanks for your help. I've worked it out now.

I'm using this formula:

=IF(SUMPRODUCT(ISNUMBER(SEARCH("break",$C$2:$R$2)) *(C3:R3=0.25)),SUMPRODUCT(ISERR(SEARCH("evt",$C$2: $R$2))*(ISERR(SEARCH("ABS",$C$2:$R$2)))*C3:R3),0)

And can expand it perfectly with more arguments. Maybe you can help me one
step further. When the result of the above formule is lower than value 0.50,
I want it to display 0.00

Any suggestions on how to accomplish this?

"Ron Rosenfeld" wrote:

Given your "small version" workbook, the following formula

=IF(SUMPRODUCT(ISNUMBER(SEARCH("break",$C$2:$R$2)) *(C3:R3=0.25)),
SUMPRODUCT(ISERR(SEARCH("evt",$C$2:$R$2))*C3:R3),0 )


should sum the rows where there is at least one heading of "break"=0.25 and EVT
does NOT appear at the heading.

If you also want to exclude ABS, then try:

=IF(SUMPRODUCT(ISNUMBER(SEARCH("break",$C$2:$R$2)) *(C3:R3=0.25)),
SUMPRODUCT(ISERR(SEARCH("evt",$C$2:$R$2)*SEARCH("a bs",$C$2:$R$2))*C3:R3),0)

But it seems to me that in column A you are excluding more than just EVT and
ABS as the values don't seem to add up.


--ron