| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with sum + if
I'm not sure I fully understood what you needed. More particularly I a unsure of what you wanted actually summed. This formula below wil perform the 'sum' operation when B2=S, D2=SEP06MAR07, and C2=-12.5. You will want to edit the actual SUM function though, because like said, I am not sure what you wanted added together. =if(B2="S",if(D2="SEP06MAR07",if(C2=-12.5,sum(B2:C3),""),""),"") Is that anything close to what you wanted done -- ph ----------------------------------------------------------------------- ph8's Profile: http://www.excelforum.com/member.php...fo&userid=1987 View this thread: http://www.excelforum.com/showthread.php?threadid=52512 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| aauugghhh...#div/o problems & various average formula problems | Excel Worksheet Functions | |||
| More zip + 4 problems | Excel Discussion (Misc queries) | |||
| Problems using Add-in | Excel Programming | |||
| Tab key problems | Excel Discussion (Misc queries) | |||
| Problems merging an excel file due to code or file problems? | Excel Programming | |||
![ph8[_50_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
