Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
{=SUM(IF(NOT(ISBLANK('Open Actions from LL'!
$F$2:$F$100)),IF('Open Actions from LL'!$C$2:$C$100=$A4,IF ('Open Actions'!$F$2:$F$100<$B$2,1,0),0),0))} I copied the above formula from another cell (not created by me). I need to add similar formula in some other cells. What are the procedures to add such formula without having to type it all. Also without knowing what are condition means and the procedures to link with one another, doesn't really help me. Can someone help me with, as to how can I add this type of formula by selecting the cells or draging a series of cells. Hope i made some sence of what I'm looking for. Feel free to call me if you like. 972-684-5386. Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Conditions in a Formula | Excel Discussion (Misc queries) | |||
multiple conditions formula | Excel Worksheet Functions | |||
Need help on formula with multiple conditions... | Excel Discussion (Misc queries) | |||
Multiple conditions in a formula | Excel Worksheet Functions | |||
How do I set up a formula with multiple conditions? | Excel Discussion (Misc queries) |