Posted to microsoft.public.excel.programming

[email protected][_2_] cjwenngatz@gmail.com[_2_] is offline

external usenet poster

Posts: 16

Function Problem.

I wrote the following conditional Sum:

=SUM(IF(OC!B3:B9999=Overview!E26,IF(OC!I3:I9999OC !
Date(2007,1,1),IF(OC!I3:I9999<OC!Date(2007,6,6),0) ,0))

Basically, range B3:B9999 has to equate to cell OverviewE26, and the
date has to be between Jan1/07 and Jun 6/06

For some reason the formula keeps erroring out on the statement: IF(OC!
I3:I9999

Any ideas? Thanks!

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
Sum function problem	Sue	New Users to Excel	9	June 19th 09 02:46 PM
If function problem	chrisnsmith	Excel Discussion (Misc queries)	5	February 7th 09 07:52 AM
Problem with IF function	FrozenRope	Excel Worksheet Functions	3	November 25th 08 01:08 AM
Problem with IF function....	neilcarden	Excel Worksheet Functions	2	March 27th 07 04:32 PM
Sum Function Problem!!	md	Excel Worksheet Functions	1	September 16th 06 10:29 AM

All times are GMT +1. The time now is 07:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us