View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SIR Knight SIR Knight is offline
external usenet poster
 
Posts: 27
Default 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