conditional formulas

deaundra · Apr 14, 2005

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 · Apr 15, 2005

=COUNTIF(B:B,"Y")

JulieD · Apr 15, 2005

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

conditional formulas

deaundra

Steve R

JulieD