conditional formulas

[Guest]

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?

 

[Steve R]

=COUNTIF(B:B,"Y")

 

[JulieD]

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