| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count cell A1 only if cell B2 = Yes
Here is my current formula that counts each sale my reps make but now i need
to only count the sale only if cell B is "yes" and not count if cell b is "No" I have tried IF formulas but i just cant get it worked out. Please help Current Formula that counts my sales reps. =COUNTIF($A$19:$A$3703, A10) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count cell A1 only if cell B2 = Yes
Try this
COUNTIF($A$19:$A$3703, "yes") -- Click Yes if correct "Frustrated" wrote: Here is my current formula that counts each sale my reps make but now i need to only count the sale only if cell B is "yes" and not count if cell b is "No" I have tried IF formulas but i just cant get it worked out. Please help Current Formula that counts my sales reps. =COUNTIF($A$19:$A$3703, A10) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count cell A1 only if cell B2 = Yes
If a yes would always be a sale why not just count the yes in B instead? If
A can be blank and B yes use =SUMPRODUCT(--($A$19:$A$3703<""),--($B$19:$B$3703="Yes")) -- Regards, Peo Sjoblom "Frustrated" wrote in message ... Here is my current formula that counts each sale my reps make but now i need to only count the sale only if cell B is "yes" and not count if cell b is "No" I have tried IF formulas but i just cant get it worked out. Please help Current Formula that counts my sales reps. =COUNTIF($A$19:$A$3703, A10) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| subtract one cell from each cell in a range and count instances | Excel Worksheet Functions | |||
| count if the cell contains a word found in another cell | Excel Worksheet Functions | |||
| How to auto count data in an empty cell to be 0. Blank cell=0 | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
Linear Mode
