The sum of the same function that is used for a range of cells
Hi Joris,
Am Tue, 24 Sep 2013 17:39:02 +0100 schrieb Drakendodertje:
=SUM(IF(0,5C40;0,5C4;0);IF(0,5C50;0,5C5;0);IF(0,5C60;0,5C6;0);IF(0,5C70;0,5C7;0);IF(0,5C80;0,5C8;0);IF(0,5C90;0,5C9;0))
This works. But like the SUM(C4:C9) formula, i would prefer to bring
this formula down to a range instead of inserting the function for each
cell seperately.
try:
=SUM(IF(C4:C9<0.5,0.5C4:C9))
and enter the arrayy formula with CTRL+Shift+Enter
Regards
Claus B.

Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
