If Then Calculate
Gladys,
There is a formula called SUMIF you can use it as follows:
=SUMIF($C3:$C100,"94411",$A3:$A100)
I have assumed that your first row of data is in row 3
This works by telling excel the area where your reference is, your
reference, and the area to total where there are matches
HTH
Steve
|