| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Countif, Sumif
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? |
|
#2
|
|||
|
|||
|
Do you mean...
=COUNTIF(RetailerRange,Retailer) =SUMIF(RetailerRange,Retailer,SumRange) reno wrote: 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? |
|
#3
|
|||
|
|||
|
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. -- nbrcrunch |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forget SUMIF, COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| Modify SUMIF and COUNTIF to work with SUBTOTALS | Excel Worksheet Functions | |||
| How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions | |||
| Countif, Sumif, If - help! | Excel Worksheet Functions | |||
Hybrid Mode
