Thanks Bernard, All good.
"Bernard Liengme" wrote:
=COUNTIF(A1:A20,"Y")
will count how many Y's in the range A1:A20
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"KG" wrote in message
...
Thanks Bernard, Is it possible to string this formula together to
basically
pluck the Y from a number of different cells and add them all together in
a
seperate cell to get a combined total.
"Bernard Liengme" wrote:
You cannot put Y in a cell and have the SAME cell do a calculation
You can put Y in one cell and have a calculation in ANOTHER cell
Suppose I enter Y (or N or nothing) in D1 and in E1 I can have
=IF(D1="Y",A1/B1,"")
When there is a Y in D1 I get the result of the calculation A1/B1
otherwise
I get blank (that is the meaning of two double quotes with nothing
between
them
best wishes
--
Bernard Liengme
MVP Excel
http://people.stfx.ca
"KG" wrote in message
...
I'm wanting to have a cell calculate a formula when I enter a 'Y' in
that
cell. Is this possible? If so, what formula/function would I use?
Thanks