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

Conditional If Statements
 

Based on your screencap, enter this formula in B10 and copy across as
needed:

=SUMIF($B1:$B6,B9,$C1:$C6)

--
Biff
Microsoft Excel MVP


"maxcw" wrote in message
...

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

Conditional If Statements
 

b10=sumif(b1:b6,b9,c1:c6)
copy the formula.
Change the range according to your data.
With regards
Sreedhar

"maxcw" wrote:


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