Adding Non-contiguous cells (Excel 97 SR2)

Topic

New Reply

I know this must be simple, but so am I. How to add a long series of non-contiguous cells that are located in a repeating interval without having to input each cell address individually. Example attached. Note that the summary table where all the adding is done would actually be on a different worksheet from all the input values. Thanks.

Reply | Quote

Replies

How about this: Put this in Cell B20 and copy to B20:D22.

=SUMIF($A$4:$A$16,$A20,B$4:B$16)

Then if you “move the summary table” to a new sheet it should redefine itself for where you move it.

Steve

Reply | Quote

Wow! What a great function. You have no idea how much time you have saved me. Many many thanks.

Reply | Quote