how can i use indirect to replace the x - 2 in the criteria argument with a cell
reference?
can't seem to figure it out.

=SUMIF(U$22:U$527,"X - 2",P$22:P$527)
--


Gary

=SUMIF(U$22:U$527,B9,P$22:P$527)

What is X then?


=SUMIF(U$22:U$527,Indirect("A" & x-2),P$22:P$527)

if x is a defined name. or if you want to refer to a cell for the value of x


=SUMIF(U$22:U$527,Indirect("A" & B3-2),P$22:P$527)

--
Regards,
Tom Ogilvy



"Gary Keramidas" wrote:


how can i use indirect to replace the x - 2 in the criteria argument with a cell
reference?
can't seem to figure it out.

=SUMIF(U$22:U$527,"X - 2",P$22:P$527)
--


Gary

x - 2 is a code for a product and it resides in a cell, U1 in this case
other codes a

w-2
bab
10r

--


Gary


"Tom Ogilvy" wrote in message
...
=SUMIF(U$22:U$527,B9,P$22:P$527)

What is X then?


=SUMIF(U$22:U$527,Indirect("A" & x-2),P$22:P$527)

if x is a defined name. or if you want to refer to a cell for the value of x


=SUMIF(U$22:U$527,Indirect("A" & B3-2),P$22:P$527)

--
Regards,
Tom Ogilvy



"Gary Keramidas" wrote:


how can i use indirect to replace the x - 2 in the criteria argument with a
cell
reference?
can't seem to figure it out.

=SUMIF(U$22:U$527,"X - 2",P$22:P$527)
--


Gary

so, i'm guessing i don't really need indirect, correct?

thanks tom

--


Gary


"Tom Ogilvy" wrote in message
...
=SUMIF(U$22:U$527,B9,P$22:P$527)

What is X then?


=SUMIF(U$22:U$527,Indirect("A" & x-2),P$22:P$527)

if x is a defined name. or if you want to refer to a cell for the value of x


=SUMIF(U$22:U$527,Indirect("A" & B3-2),P$22:P$527)

--
Regards,
Tom Ogilvy



"Gary Keramidas" wrote:


how can i use indirect to replace the x - 2 in the criteria argument with a
cell
reference?
can't seem to figure it out.

=SUMIF(U$22:U$527,"X - 2",P$22:P$527)
--


Gary

Not with sumif.

--
Regards,
Tom Ogilvy


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
so, i'm guessing i don't really need indirect, correct?

thanks tom

--


Gary


"Tom Ogilvy" wrote in message
...
=SUMIF(U$22:U$527,B9,P$22:P$527)

What is X then?


=SUMIF(U$22:U$527,Indirect("A" & x-2),P$22:P$527)

if x is a defined name. or if you want to refer to a cell for the value
of x


=SUMIF(U$22:U$527,Indirect("A" & B3-2),P$22:P$527)

--
Regards,
Tom Ogilvy



"Gary Keramidas" wrote:


how can i use indirect to replace the x - 2 in the criteria argument
with a cell
reference?
can't seem to figure it out.

=SUMIF(U$22:U$527,"X - 2",P$22:P$527)
--


Gary