| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
