| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
conditional formulas
i would like to create a conditional formula to count how many times a name
in column B shows if there is a "Y" in column G. Can someone please please please help me? |
|
#2
|
|||
|
|||
|
=COUNTIF(B:B,"Y")
"deaundra" wrote in message ... i would like to create a conditional formula to count how many times a name in column B shows if there is a "Y" in column G. Can someone please please please help me? |
|
#3
|
|||
|
|||
|
Hi
use the sumproduct funtion =SUMPRODUCT(--(B1:B100="Bill"),--(G1:G100="Y")) check out http://www.xldynamic.com/source/xld.SUMPRODUCT.html for more details on how this function works -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "deaundra" wrote in message ... i would like to create a conditional formula to count how many times a name in column B shows if there is a "Y" in column G. Can someone please please please help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i use colors in conditional formulas if i want the result. | Excel Discussion (Misc queries) | |||
| How to create Multiple Conditional Formulas in a single cell? | Excel Discussion (Misc queries) | |||
| Help Using Formulas in Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting using result of Cell Formulas | Excel Discussion (Misc queries) | |||
| Duplicate Conditional Sum Formulas | Excel Worksheet Functions | |||
Linear Mode
