| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM IF with conditions in another column
I've been using =SUMIF(C$5:C$317,"0.5") - column C can contain any value
between 1 and 50 or text and I need the sum of any numerical values, but I only need it to use this if cells in column B meet a particular criteria. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function/sum function | Excel Discussion (Misc queries) | |||
| How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Add items in column 3 if column 1 and 2 conditions are met | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Threaded Mode
