It sounds like you need SUMIF - the syntax is =SUMIF(range, criteria,
sumrange), so it should look something like
=SUMIF(B5:B3000,"Active",C5:C3000)

On Oct 8, 2:26*pm, Dale08406
wrote:
I need a sales spreadsheet that can add up only certain cells in one column
that have a particular designation - such as those products that are ACTIVE
or DISCONTINUED (noted as A or D in a separate column). *These cells/lines
cannot be grouped together and are too numerous to simply touch-highlight
each cell, PLUS the designation will be changed for some cells on a regular
basis. * Is there a formula that will allow me to only add up those lines
that are designated A? Thanks.