| 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
Thank you everyone! The =sumif that you all suggested worked perfectly! You
are all very helpful and thank you for the quick response! Kristen Bill Kuunders wrote: =sumproduct(--(F1:F1000="B"),(E1:E1000)) sumproduct needs a defined column length. I selected 1000 or you could try =sumif(F1:F1000,"B",E1:E1000) with a sumproduct formula you can have more than one condition see.....http://www.xldynamic.com/source/xld.SUMPRODUCT.html Hi All! [quoted text clipped - 11 lines] Thank you! Kristen -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200802/1 |
| Reply |
| 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) | |||
Hybrid Mode
