Excel 2007 : Sum columns by criteria

[rawas]

how to sum range of B:V columns by criteria sum range is B:V
criteria range1 is A:A
criteria1 = "apple"
criteria range2 is row 1
criteria2 = "AN"

the formula sumifs(B:V;A:A;"apple";1:1;"AN") return error? what is wrong?
array formula does not good for me because i have to calculate a lot of fields.

[NBVC]

Try

=SUMPRODUCT(($A$2:$A$10="apple")*($B$1:$V$1="AN"),$B$2:$V$10)

adjust ranges to suit and do not use whole column references.

[rawas]

Try

=SUMPRODUCT(($A$2:$A$10="apple")*($B$1:$V$1="AN"),$B$2:$V$10)

adjust ranges to suit and do not use whole column references.

but i have dinamic range? and array formula has defekt its return error if value in sum range is N/A

[NBVC]

If you posted an actual workbook instead of a picture of part of it, and telling us about dynamic ranges in advance... you may get more accurate results the first time. What do you mean by defect?

How are the dynamic ranges defined?