| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountIF or SumIF
I need a formula that will first look in column A for a name, then look in
column b and count how many times a certain value appears for that name. ColumnA Column B Scott Agree John Agree Scott Agree How many times does scott have a agree? Answer: 2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forget SUMIF, COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
| How do I set up a countif, or sumif that is multiconditional? | Excel Worksheet Functions | |||
| problems with sumif and countif | Excel Discussion (Misc queries) | |||
| Modify SUMIF and COUNTIF to work with SUBTOTALS | Excel Worksheet Functions | |||
| Countif, Sumif, If - help! | Excel Worksheet Functions | |||
Threaded Mode
