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?

=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?

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?