Countif, Sumif

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

Guest

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?
 
Do you mean...

=COUNTIF(RetailerRange,Retailer)

=SUMIF(RetailerRange,Retailer,SumRange)
 
You must log in or register to reply here.

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

Compare a value and if is true copy the line to other worksheet 3
Subtotals of repeating set of data 2
Round numbers up or down and always end in an 8 3
Lookup problem 4
hi - Two columns 1
only include cells beginning with specified character or number 3
countif multiple criteria 1
Using COUNTIF and VLOOKUP with upper and lower case letters 5

Back
Top