Posted to microsoft.public.excel.worksheet.functions

Griffey5

external usenet poster

Posts: 13

Excel Formula Error

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why does Excel say this formula contains an error?	HuskerBronco	Excel Worksheet Functions	12	July 15th 06 10:26 PM
How do I correct error using the =IF(AND(formula in excel?	Redwing ML	Excel Worksheet Functions	0	March 1st 06 03:20 PM
How do I correct error using the =IF(AND(formula in excel?	Redwing ML	Excel Worksheet Functions	6	March 1st 06 01:24 PM
Excel Formula Error	VikiFynn	Excel Worksheet Functions	1	October 27th 05 03:48 PM
Excel Calculation Error for formula to sum	longer	Excel Discussion (Misc queries)	3	April 29th 05 03:40 PM

All times are GMT +1. The time now is 01:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us