Help?

[Dylan]

I can't get this formula to work, please help.

=IF(COUNTIF(B128,"<Z*"),0,SUM(SUMIF((F128,F270),F128>0,(F2,F270)),(SUMIF((G128,G270),G128>0)),(SUMIF((H128,H270),H128>0))))

The logic is this:

If B128 is not a number result = 0
Else Sum the following three together
If F2 is >0 Sum F2,$F$128, 0
If G2 is >0 Sum G2,$G$128, 0
If H2 is >0 Sum H2,$H$128, 0

 

[Sandy Mann]

I can't get your formula to match your logic but going by:

If B128 is not a number result = 0
Else Sum the following three together
If F2 is >0 Sum F2,$F$128, 0
If G2 is >0 Sum G2,$G$128, 0
If H2 is >0 Sum H2,$H$128, 0

does this do what you want?

=IF(ISTEXT(B128),0,IF(F2>0,F2+F128)+IF(G2>0,G2+G128)+IF(H2>0,H2+H128))
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[David Biddulph]

You probably need to go to Excel help and remind yourself of the syntax of
the functions you are using.

 

[Teethless mama]

=IF(ISNUMBER(B128),SUMPRODUCT((F2:H2>0)*(F2:H2+F128:H128)),0)