Count if...

  • Thread starter Thread starter bruness
  • Start date Start date
B

bruness

hi.
have a problem in finding the formula for this:
___A___B___
1__1__DVD__
2__1__DIVX__
3__2__DVD__
4__2__DIVX__
5__1__DVD__

what i want is the sum in cell C7 that do this
sum all DVD the result of the formula musta be in this case 3
 
One way

=COUNTIF(B1:B5,"DVD")

if you want to sum the numbers in A where B is DVD

=SUMIF(B1:B5,"DVD",A1:A5)
 
brun

I have trouble with your addition. But maybe I'm interpreting incorrectly?

=SUMIF(B1:B5,"DVD",A1:A5) returns 4 (1+2+1)

Gord Dibben Excel MVP
 
Back
Top