Help?
 

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

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

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

Help?
 

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(F20,F2+F128)+IF(G20,G2+G12 8)+IF(H20,H2+H128))
--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Dylan" wrote in message
...
I can't get this formula to work, please help.

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

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

Help?
 

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

"Dylan" wrote in message
...
I can't get this formula to work, please help.

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

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

Help?
 

=IF(ISNUMBER(B128),SUMPRODUCT((F2:H20)*(F2:H2+F12 8:H128)),0)


"Dylan" wrote:

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

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

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