Countif, Sumif

[reno]

want to count/sum, using an adjacent column is true, e.g.
Distributor 2,300
SD-Retailer 120
Retailer 101
SD-Retailer 33
SD-Retailer 8
SD-Retailer 6
SD-Retailer 6
SD-Retailer 4
In this example want to count and or sum the numbers based on Distributor, etc
any suggestions?

 

[Aladin Akyurek]

Do you mean...

=COUNTIF(RetailerRange,Retailer)

=SUMIF(RetailerRange,Retailer,SumRange)

 

[nbrcrunch]

Your post is a bit cryptic but I'll take a stab at it...

You have two columns. In the first is the descriptor, in the second is
the value.

You can use the CountIf() and SumIf() functions to accomplish what you
want. See Excel's helpfile for details.