Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional statements | Excel Worksheet Functions | |||
Conditional Statements Help! | Excel Discussion (Misc queries) | |||
Conditional statements | Excel Worksheet Functions | |||
Conditional IF statements | Excel Worksheet Functions | |||
Conditional Statements | Excel Discussion (Misc queries) |