Need formula to calculate/add cells with certain designation
Hi
SUMIF is what you're after:
=SUMIF(DesignationColumn,"A",ValueColumn)
eg if Values were in G column and Designation in col B the formula wouldbe:
=SUMIF(B:B,"A","G:G")
assuming the formula itself is not in either the G or B columns (to avoid a
circular reference - you can restrict the ranges if required eg use B2:B100
instead of B:B). The criteria ie "A" can be a reference to a cell holding
this value.
Best regards
Richard
"Dale08406" wrote in message
...
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.
|