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.

HTH,

Kevin M
MOS Excel Specialist

"Hirsch" wrote:

=SUMIF(B:B,B92,AE:AE)+SUMIF(B:B,B92,AI:AI)+sumif(b :b,b92,AK:AK)

This was the start to one formula on a spread sheet, my simple question is
can this be condensed. is there such thing as
=sumif(b:b,b92,ae:ae&ai:ai&ak:ak) -

The whole purpose of condensing the formula is to be allow others to follow
the path especially auditors.