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.
 
Back
Top