no the existing formula is about as simple as you will be able to get

"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.