![]() |
Counting non-numeric values
Assuming your row is Row 1....
=COUNTIF(1:1,"=x") Change the two 1's to whatever row number your x's are in. Rick "paljowestsub" wrote in message ... I have a spreadsheet with the letter x in various cells. I want to count the number of x's in a particular row of cells. What formula do I use and how do I structure the formula? Thank you! Joe Palczynski |
All times are GMT +1. The time now is 02:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com