array formula - ExcelBanter

Posted to microsoft.public.excel.programming

scrabtree[_2_] scrabtree[_2_] is offline

external usenet poster

Posts: 47

array formula

How can I re-write the code below so that it finds the
data for F14:F1403 that is between 100000 and 200000?

SUM(($D$14:$D$1403=$B$1)*(F14:F1403<200000)*
($C$14:$C$1403=$B$6)))+(SUM(($D$14:$D$1403=$B$1)*
(F14:F1403199999)*($C$14:$C$1403=$B$6))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Array formula SUMIF with 2D sum_range array	Rich_84	Excel Worksheet Functions	3	April 3rd 09 10:46 PM
Array formula: how to join 2 ranges together to form one array?	Rich_84	Excel Worksheet Functions	2	April 1st 09 06:38 PM
Find specific value in array of array formula	DzednConfsd	Excel Worksheet Functions	2	January 13th 09 06:19 AM
meaning of : IF(Switch; Average(array A, array B); array A)	DXAT	Excel Worksheet Functions	1	October 24th 06 06:11 PM
Array Formula - using LEFT("text",4) in formula	Andrew L via OfficeKB.com	Excel Worksheet Functions	2	August 1st 05 02:36 PM

All times are GMT +1. The time now is 11:35 PM.

Menu

About Us