| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help on formula with multiple conditions...
I know this can be done ... but I'm not exactly sure how. Let's say we have 3 columns. Column A contains names which are not unique. Column B contains a code to indicate, in this case a source for the data. Column C has the data that needs to be summed... I have used =sumif(A1:A50,"Joe Smith",C1:C50) - but how do I get it to add only Joe Smith's cells in column C when the letter E is in column B? It's driving me crazy...  -- DiDi ------------------------------------------------------------------------ DiDi's Profile: http://www.excelforum.com/member.php...o&userid=33473 View this thread: http://www.excelforum.com/showthread...hreadid=532772 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple conditions in a formula | Excel Worksheet Functions | |||
| formula to fill text with multiple conditions | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Sum(if ... multiple conditions ... Interpretation? | Excel Discussion (Misc queries) | |||
Threaded Mode
