Counting non-numeric values
You did say ROW, right?
For an *entire* row, say Row5: =Countif(5:5,"x") For a range of cells within Row5: =Countif(C5:Y5,"x") -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "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 06:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com