About Us

adimar

Is there a more compact way of writing the formula below, where comparison
cells contain dates and text?

=SUMPRODUCT((Product="ABC")*(RawData!$E1:$E10000= CalculatedData!B2)*(RawData!$E1:$E10000<=Calculate dData!B3)*(RawData!$G$1:$G$10000
<B15)*(RawData!$G$1:$G$10000 <B16)*(RawData!$G$1:$G$10000
<B17)*(RawData!$G$1:$G$10000 <B18)*(RawData!$G$1:$G$10000
<B19)*(RawData!$G$1:$G$10000 <B20)*(RawData!$G$1:$G$10000
<B21)*(RawData!$G$1:$G$10000 <B22)*(RawData!$G$1:$G$10000
<B23)*(RawData!$G$1:$G$10000 <B24)*(RawData!$G$1:$G$10000
<B25)*(RawData!$G$1:$G$10000 <B26)*(RawData!$G$1:$G$10000
<B27)*(RawData!$G$1:$G$10000 <B28))

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMPRODUCT w/ 3 criteria	jane	Excel Worksheet Functions	3	November 9th 07 11:26 PM
sumproduct and IF criteria??	ferde	Excel Discussion (Misc queries)	5	March 24th 07 06:11 PM
SUMPRODUCT - 2 Criteria	Sam via OfficeKB.com	Excel Worksheet Functions	23	February 10th 07 01:52 AM
Sumproduct 4 criteria	Laura	Excel Worksheet Functions	0	November 29th 06 11:02 PM
Sumproduct with two criteria	Rob	Excel Worksheet Functions	9	February 10th 06 03:15 AM

Menu

About Us