Sumif??

  • Thread starter Thread starter Hope
  • Start date Start date
H

Hope

I have 3 columns...

A - defect description
B - number of defects
C - equipment

I am trying to sum the number of defects if both the defect description and
equipment match the criteria.

Thanks in advance!

Hope
 
What is the purpose of the dashes? My current result comes back as zero. Is
there a way for me to try part of the formula at a time to see which portion
is not functioning correctly?
 
In SUMPRODUCT, when you compare a cell range ($A$2:$A$100) to some value
(such as your description), this will force a series of TRUE or FALSE. The
dashes change this value from TRUE or FALSE to 1 or 0. So you have 2 ranges
that will be 1 or 0 depending on whether or not they meet the criteria, then
the final range is the range you want 'summed'.
Understand also that my 2 variables of description and equipment are in
lowercase as you have to define those, either put the ones you are trying to
count for in separate cells or 'hardcode' the formula itself
Perhaps if you were to show your actual formula, and a snippet of your data
(sample is fine), that 'should' be calculating some results.
 
If you post your formula(s), I can verify for you if everything will work
based on your conditions given, otherwise, glad you got it working :)
 
Hi John-
I'm having a similar problem that I hope you can help with- wanting to sum
amounts in column B if column C has an R next to it: Example
A B C
3 $40
17 $5 R
11 $10 R
32 $30
12 $10 R

and so on..... Only want the $ amount for column B if C has an "R"

Thank you in advance for your help!
 
Back
Top