Conditional Sum w/o using the Wizard.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I use this formula, I get a #VALUE error.

=SUM(IF(I9:I17="aaa",K9:K17,0))

I want to look for "aaa" in cells I9 thur I17 and sum the numbers in cells
K9 thru K17 for each occurance of "aaa" in cells I9 thru I17.
 
How about =sumif()

=sumif(i9:i17,"aaa",k9:k17)
When I use this formula, I get a #VALUE error.

=SUM(IF(I9:I17="aaa",K9:K17,0))

I want to look for "aaa" in cells I9 thur I17 and sum the numbers in cells
K9 thru K17 for each occurance of "aaa" in cells I9 thru I17.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Too many arguements for this function"....ohh noooo.... 3
aauugghhh...#div/o problems & various average formula problems 5
formula not working right 2
reference cell from previous worksheet without "naming" worksheet 3
Conditional Formatting: Logical AND fails to work with INDIRECT(.. 5
#VALUE! error 3
conditional formatting update issue 5
SUM cells with blank value 10

Back
Top