I am trying to use sum product and I have tried this several ways. The most
recent is =SUMPRODUCT(--('Buy Tool'!K:K="Heather"),--('Buy
Tool'!L:L="b"),('Buy Tool'!AR:AR)). I am trying to sum the amounts in AR:AR
where the both of these critieria are met. I get a #num error. What am I
doing wrong?

Hi

WIth SUMPRODUCT, you can't use full column references. Instead of K:K, for
example, use K1:K10000.

Andy.

"Rob" wrote in message
...
I am trying to use sum product and I have tried this several ways. The
most
recent is =SUMPRODUCT(--('Buy Tool'!K:K="Heather"),--('Buy
Tool'!L:L="b"),('Buy Tool'!AR:AR)). I am trying to sum the amounts in
AR:AR
where the both of these critieria are met. I get a #num error. What am I
doing wrong?

That did it, thanks so much. Let me ask another question. How do I create a
parameter query that will look up and only show the rows where I specifiy the
criteria in one column. Say for instance, I want to be able to type in
"Heather" in a pop up box and it will display the rows that have "Heather".

"Andy" wrote:

Hi

WIth SUMPRODUCT, you can't use full column references. Instead of K:K, for
example, use K1:K10000.

Andy.

"Rob" wrote in message
...
I am trying to use sum product and I have tried this several ways. The
most
recent is =SUMPRODUCT(--('Buy Tool'!K:K="Heather"),--('Buy
Tool'!L:L="b"),('Buy Tool'!AR:AR)). I am trying to sum the amounts in
AR:AR
where the both of these critieria are met. I get a #num error. What am I
doing wrong?

Well, that sounds like a job for Data/Filter/Autofilter - unless you want to
get into macros.

Andy.

"Rob" wrote in message
...
That did it, thanks so much. Let me ask another question. How do I
create a
parameter query that will look up and only show the rows where I specifiy
the
criteria in one column. Say for instance, I want to be able to type in
"Heather" in a pop up box and it will display the rows that have
"Heather".

"Andy" wrote:

Hi

WIth SUMPRODUCT, you can't use full column references. Instead of K:K,
for
example, use K1:K10000.

Andy.

"Rob" wrote in message
...
I am trying to use sum product and I have tried this several ways. The
most
recent is =SUMPRODUCT(--('Buy Tool'!K:K="Heather"),--('Buy
Tool'!L:L="b"),('Buy Tool'!AR:AR)). I am trying to sum the amounts in
AR:AR
where the both of these critieria are met. I get a #num error. What
am I
doing wrong?

And by the way, I figured out how to add additional criteria with the + sign
within the sumproduct statement. Thanks again.

"Andy" wrote:

Well, that sounds like a job for Data/Filter/Autofilter - unless you want to
get into macros.

Andy.

"Rob" wrote in message
...
That did it, thanks so much. Let me ask another question. How do I
create a
parameter query that will look up and only show the rows where I specifiy
the
criteria in one column. Say for instance, I want to be able to type in
"Heather" in a pop up box and it will display the rows that have
"Heather".

"Andy" wrote:

Hi

WIth SUMPRODUCT, you can't use full column references. Instead of K:K,
for
example, use K1:K10000.

Andy.

"Rob" wrote in message
...
I am trying to use sum product and I have tried this several ways. The
most
recent is =SUMPRODUCT(--('Buy Tool'!K:K="Heather"),--('Buy
Tool'!L:L="b"),('Buy Tool'!AR:AR)). I am trying to sum the amounts in
AR:AR
where the both of these critieria are met. I get a #num error. What
am I
doing wrong?

Well, believe it or not, I just started doing these if statements and nested
if statements and have learned very quickly am using these calculations on a
34Mb spreadsheet which includes macros. I can decipher and touch them up
after I record them and add some additional VBA code. If you give me a
start, I can do the rest I think.

"Andy" wrote:

Well, that sounds like a job for Data/Filter/Autofilter - unless you want to
get into macros.

Andy.

"Rob" wrote in message
...
That did it, thanks so much. Let me ask another question. How do I
create a
parameter query that will look up and only show the rows where I specifiy
the
criteria in one column. Say for instance, I want to be able to type in
"Heather" in a pop up box and it will display the rows that have
"Heather".

"Andy" wrote:

Hi

WIth SUMPRODUCT, you can't use full column references. Instead of K:K,
for
example, use K1:K10000.

Andy.

"Rob" wrote in message
...
I am trying to use sum product and I have tried this several ways. The
most
recent is =SUMPRODUCT(--('Buy Tool'!K:K="Heather"),--('Buy
Tool'!L:L="b"),('Buy Tool'!AR:AR)). I am trying to sum the amounts in
AR:AR
where the both of these critieria are met. I get a #num error. What
am I
doing wrong?