ExcelBanter - Need to calculate simple formula for cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Need to calculate simple formula for cells (https://www.excelbanter.com/excel-discussion-misc-queries/144610-need-calculate-simple-formula-cells.html)

victoriaawatson

Need to calculate simple formula for cells

I have a spreadsheet that uses columns A - Z, in some of the cells up
to here, I have the word 'yes'.

I need to know how to calculate the number of 'yeses' in the cell to
come up with how many I have.

How do I do it?

Thanks

Gary''s Student

Need to calculate simple formula for cells

=COUNTIF(A:Z,"yes")

--
Gary''s Student - gsnu200726

All times are GMT +1. The time now is 10:39 AM.