"Kevin M" wrote...
Hirsch, you can use the formula DSUM. This will sum based on
criteria you set outside the data by using the Column heading
as the reference and then your criteria underneath. The help
menu has a useful entry on this formula.
....
"Hirsch" wrote:
=SUMIF(B:B,B92,AE:AE)+SUMIF(B:B,B92,AI:AI)+sumif (b:b,b92,AK:AK)
....


How would DSUM help in this case? Neither SUMIF nor DSUM can directly sum
multiple columns/fields. It's hard to see how something like

=DSUM($A:$AZ,31,CR)+DSUM($A:$AZ,35,CR)+DSUM($A:$AZ ,37,CR)

would be all that much of an improvement. Note that CR is a reference to a
criteria range.

This can be condensed with trickery,

=SUM(SUMIF(B:B,B92,OFFSET(AE:AE,0,{0,4,6}))

but the result is obscure at best.