View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Conditional Calculations???????

SUMIF should work - try this:

=SUMIF(C$2:C$100,"S",B$2:B$100), and
=SUMIF(C$2:C$100,"J",B$2:B$100)

These assume items to row 100 - adjust as necessary.

Hope this helps.

Pete