Formula with multiple conditions

  • Thread starter Thread starter Mohammed
  • Start date Start date
M

Mohammed

{=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.
 
This is an array formula that is checking the values of different ranges in
another workbook named Open Actions from LL, and then summing the IF results
to produce a 1 or 0. You can simply copy the formula from the cell to
another cell with Paste Special Formulas. If you were to type it out by
hand, you would not type the curly brackets that enclose the formula,
instead enter it with Ctrl-Shift-Enter. Excel will put in the Curly
brackets.
Hope this helps, Mike
 
Back
Top