Summing one column where criteria in two other columns are met

R

Rob

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?
 
G

Guest

Hi

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

Andy.
 
R

Rob

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".
 
G

Guest

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

Andy.
 
R

Rob

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.
 
R

Rob

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