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.