Asked by BluSkyBill
at 2024-07-10 02:04:19
Point:500 Replies:5 POST_ID:828944USER_ID:11843
Topic:
Office Suites;Microsoft Office Suite;Microsoft Excel Spreadsheet Software
I have a row of numbers C31 E31, G31, I17 AND K31 WHICH MAY OR MAY CONTAIN A POSITIVE OR NEGATIVE NUMBER
I NEED TO KNOW HOW MANY CELLS CONTAIN A NUMBER. =COUNTIF(C31..K31,<>"0") WILL NOT WORK BECAUSE THERE IS TEXT IN D31, F31, H31, J31 AND L31. HOW DO I TEST FOR THE PRESENCE OF A REAL NUMBER, BE IT POSITIVE OR NEGATIVE?
I NEED TO KNOW HOW MANY CELLS CONTAIN A NUMBER. =COUNTIF(C31..K31,<>"0") WILL NOT WORK BECAUSE THERE IS TEXT IN D31, F31, H31, J31 AND L31. HOW DO I TEST FOR THE PRESENCE OF A REAL NUMBER, BE IT POSITIVE OR NEGATIVE?
