| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Cell Values of one column based on Another Cell Value in a different column
Hi All!
I need to place the sum of certain cell values in a separate cell. Easy enough, except for one thing: Here's the deal. If F21 has "B" in it, that's when I need E21's value added. If there is ANYTHING else in column F, don't add the value of the corresponding E column cell. I would like a function formula that I will place in E6 that will work for the entire columns E & F. Let me know if you need additional information to understand my query. Thank you! Kristen -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200802/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM values in this column F only if cell is blank in column Q...HE | Excel Discussion (Misc queries) | |||
| Count entries in one column based on values in another column | Excel Worksheet Functions | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
| Hide column or row based on a cell in the column or row? | Excel Discussion (Misc queries) | |||
| Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
Threaded Mode
