| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Errors
What is wrong with this formula?
=SUM(IF(('Batch Log'!A2:A2001="February")*('Batch Log'!G2:G2001="530204-03")*('Batch Log'!H2:H2001="3000272.02"),'Batch Log'!F2:F2001,0)) It will compute successfully with just the first two conditions, but cannot when the third condition is added. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula Errors
Three questions:
Did you enter it as an array formula (Control Shift Enter) ? Are you sure that your column H data are text strings (as you've put the ="3000272.02" condition in quotes) ? Did you try it with just the 3rd condition, removing the 1st and 2nd ? -- David Biddulph "Griffey5" wrote in message ... What is wrong with this formula? =SUM(IF(('Batch Log'!A2:A2001="February")*('Batch Log'!G2:G2001="530204-03")*('Batch Log'!H2:H2001="3000272.02"),'Batch Log'!F2:F2001,0)) It will compute successfully with just the first two conditions, but cannot when the third condition is added. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula Errors
Pray tell, which is the third condition?
-- Don Guillett Microsoft MVP Excel SalesAid Software "Griffey5" wrote in message ... What is wrong with this formula? =SUM(IF(('Batch Log'!A2:A2001="February")*('Batch Log'!G2:G2001="530204-03")*('Batch Log'!H2:H2001="3000272.02"),'Batch Log'!F2:F2001,0)) It will compute successfully with just the first two conditions, but cannot when the third condition is added. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula Errors
I entered it as an array and column H is entered as text
I have not tried it with just the last condition. "David Biddulph" wrote: Three questions: Did you enter it as an array formula (Control Shift Enter) ? Are you sure that your column H data are text strings (as you've put the ="3000272.02" condition in quotes) ? Did you try it with just the 3rd condition, removing the 1st and 2nd ? -- David Biddulph "Griffey5" wrote in message ... What is wrong with this formula? =SUM(IF(('Batch Log'!A2:A2001="February")*('Batch Log'!G2:G2001="530204-03")*('Batch Log'!H2:H2001="3000272.02"),'Batch Log'!F2:F2001,0)) It will compute successfully with just the first two conditions, but cannot when the third condition is added. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula Errors
I tried using the last condition only and it does nothing. So the problem is
in the last condition. I don't see what the problem could be. "David Biddulph" wrote: Three questions: Did you enter it as an array formula (Control Shift Enter) ? Are you sure that your column H data are text strings (as you've put the ="3000272.02" condition in quotes) ? Did you try it with just the 3rd condition, removing the 1st and 2nd ? -- David Biddulph "Griffey5" wrote in message ... What is wrong with this formula? =SUM(IF(('Batch Log'!A2:A2001="February")*('Batch Log'!G2:G2001="530204-03")*('Batch Log'!H2:H2001="3000272.02"),'Batch Log'!F2:F2001,0)) It will compute successfully with just the first two conditions, but cannot when the third condition is added. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula Errors
Don:
Last condition is : ('Batch Log'!H2:H2001="3000272.02"), "Don Guillett" wrote: Pray tell, which is the third condition? -- Don Guillett Microsoft MVP Excel SalesAid Software "Griffey5" wrote in message ... What is wrong with this formula? =SUM(IF(('Batch Log'!A2:A2001="February")*('Batch Log'!G2:G2001="530204-03")*('Batch Log'!H2:H2001="3000272.02"),'Batch Log'!F2:F2001,0)) It will compute successfully with just the first two conditions, but cannot when the third condition is added. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula Errors
|
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula Errors
It's already been suggested in the other thread in the functions group.
To the Griffey5 ... Do you see how this multi-posting of yours wastes peoples time and efforts, duplicating suggestions already made? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Don Guillett" wrote in message ... try =3000272.02 instead -- Don Guillett Microsoft MVP Excel SalesAid Software "Griffey5" wrote in message ... I tried using the last condition only and it does nothing. So the problem is in the last condition. I don't see what the problem could be. "David Biddulph" wrote: Three questions: Did you enter it as an array formula (Control Shift Enter) ? Are you sure that your column H data are text strings (as you've put the ="3000272.02" condition in quotes) ? Did you try it with just the 3rd condition, removing the 1st and 2nd ? -- David Biddulph "Griffey5" wrote in message ... What is wrong with this formula? =SUM(IF(('Batch Log'!A2:A2001="February")*('Batch Log'!G2:G2001="530204-03")*('Batch Log'!H2:H2001="3000272.02"),'Batch Log'!F2:F2001,0)) It will compute successfully with just the first two conditions, but cannot when the third condition is added. |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula Errors
Just changing the format does mean you changed text to a number.
Format to General then re-enter 3000272.02 Gord Dibben MS Excel MVP On Sun, 6 Jan 2008 14:06:02 -0800, Griffey5 wrote: Didn't work this way either. I changed the format to make it a number instead of text and took off the "" still not working. "Don Guillett" wrote: try =3000272.02 instead -- Don Guillett Microsoft MVP Excel SalesAid Software "Griffey5" wrote in message ... I tried using the last condition only and it does nothing. So the problem is in the last condition. I don't see what the problem could be. "David Biddulph" wrote: Three questions: Did you enter it as an array formula (Control Shift Enter) ? Are you sure that your column H data are text strings (as you've put the ="3000272.02" condition in quotes) ? Did you try it with just the 3rd condition, removing the 1st and 2nd ? -- David Biddulph "Griffey5" wrote in message ... What is wrong with this formula? =SUM(IF(('Batch Log'!A2:A2001="February")*('Batch Log'!G2:G2001="530204-03")*('Batch Log'!H2:H2001="3000272.02"),'Batch Log'!F2:F2001,0)) It will compute successfully with just the first two conditions, but cannot when the third condition is added. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mod a Formula For Errors | Excel Worksheet Functions | |||
| Formula Errors | Excel Discussion (Misc queries) | |||
| Formula errors | Excel Worksheet Functions | |||
| Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
| Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
Linear Mode
