View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
maxcw maxcw is offline
external usenet poster
 
Posts: 1
Default Conditional If Statements


In column B I have list of values ranging from 1 - 8
Next to it in column C I have a list of costs.

I cant figure out how to total the costs the fall under a particular
value in B

For Example

If a cell in Column B has a value of 2 Add the value of the
corresponding cell in C to the total.

I've included a photo, cause I'm sure I'm making zero sense.

[image: http://img.photobucket.com/albums/v518/maxcw/excel.jpg]




--
maxcw