MS Excel help

jessie_refined, Jul 3, 7:18pm
i would like a formula to count the number of "Y" in a range of cells.

ie A1, A2, A3 all have a Y and the answer is 3

gyrogearloose, Jul 3, 8:17pm
If you press the F1 key a search box opens, type your question "i would like a formula to count the number of "Y" in a range of cells" into the search box and it will give you the answer.


peric, Jul 3, 8:34pm
Cell B1 say, type =if(A1="Y",1,0) copy down the range required. Then SUM

ralphdog1, Oct 25, 2:46am
=COUNTIF(A1:A7,"Y")
Counts how may cells between A1 and A7 have a Y in them

Share this thread

Buy me a coffee :)Buy me a coffee :)