Creating a range using an array in the sum product

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=SUMPRODUCT((DATA!U2:U8349=35630)*(DATA!AC2:AC8349=1),DATA!AJ2:AJ8349

that is my working string

How ever I would love to save myself about 8 hours of programming if there is a way to sa

i want it to search all zip codes between 35600 and 35699 which is my data in Column U in the above formula

Is that possible
 
Hi
use
=SUMPRODUCT((DATA!U2:U8349>=35600)*(DATA!U2:U8349<=35699)*
(DATA!AC2:AC8349=1),DATA!AJ2:AJ8349)
-----Original Message-----
=SUMPRODUCT((DATA!U2:U8349=35630)*(DATA! AC2:AC8349=1),DATA!AJ2:AJ8349)

that is my working string.

How ever I would love to save myself about 8 hours of
Click to expand...
programming if there is a way to say
i want it to search all zip codes between 35600 and
Click to expand...
35699 which is my data in Column U in the above formula.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using SUM + INDEX in array formula 5
Sum multiple criteria with a range >than and < than 5
Conditional Arrays 1
Understanding the objective '--' used in SUM PRODUCT function 11
specify an ending row in an array formula 3
Array - conditionally sum the 1st occurence in non-contiguous rang 1
how to reverse a range/array? 5
sum a range based on criteria in rowdata and column name 5

Back
Top