Is this easier to understand?
=SUMPRODUCT((B1:B1000=B92)*(AK1:AK1000+AE1:AE1000+ AI1:AI1000))
With Sumproduct however, you can't use total column references (B:B, AK:AK,
.... etc.).
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Hirsch" wrote in message
...
=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.
|