View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Help Please SUMIF question

One way:

Use cells to hold the ID boundaries:

A1 = 1230000000
B1 = 1230099999

=SUMIF(UPC,"="&A1,Sales)-SUMIF(UPC,""&B1,Sales)


--
Biff
Microsoft Excel MVP


"baz" wrote in message
...
I am using Excel in Office XP. I have a set of values pertaining to a
unique
identifier. These unique id's would be a range from say 1230000000 to
1230099999 for one manufacturer and and I have named this range "UPC."
There
are other manufacturers with similar ranges and my intent is to replicate
the
above in another cell and just change the upc value in the argument.

I have named my range where I want the values from as "sales."

I want the total in cell c10 to be a SUMIF of the upc range with all of
the
upc's from 1230000000 to 1230099999.

I hope this makes sense and thanks in advance,

baz