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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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

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
>