Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by BluSkyBill
at 2024-07-10 02:04:19
ModifyPoint: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?
Expert: duncanb7 replied at 2024-07-10 02:29:21
Please try this simple "countif" to count how many cells that is positive or negative number in range of C31:K31, and it works from my side
=COUNTIF(C31:K31,">0")+COUNTIF(C31:K31,"<0")+COUNTIF(C31:K31,"=0")
Duncan
=COUNTIF(C31:K31,">0")+COUNTIF(C31:K31,"<0")+COUNTIF(C31:K31,"=0")
Duncan
Expert: imnorie replied at 2024-07-10 02:26:08
This will count the no of cells with numbers in them in C31, E31, G31, I31 and K31.
=SUMPRODUCT(--(MOD(COLUMN(C31:K31),2)=1), --(ISNUMBER(C31:K31)))
PS I'm assuming I17 is a typo and should be I31.
=SUMPRODUCT(--(MOD(COLUMN(C31:K31),2)=1), --(ISNUMBER(C31:K31)))
PS I'm assuming I17 is a typo and should be I31.
Author: BluSkyBill replied at 2024-07-10 02:24:51
Excellent. Thank you
Expert: Robby Swartenbroekx replied at 2024-07-10 02:16:35
put a row below row 31 (hide it afterwards to make the layout look the same).
In Call C32 put this formula:
In Call C32 put this formula:
copy this one to the right up until cell K32
this one gives True or false.
Now count the number of true's in row 32
you can now hide row 32
Accepted Solution
Expert: johnb25 replied at 2024-07-10 02:10:04
500 points GOOD
Hi,
If you are excluding 0 from your count this will work:
=COUNT(C31:K31)-COUNTIF(C31:K31,0).
If there can be no 0 then you don't need the second part.
John
If you are excluding 0 from your count this will work:
=COUNT(C31:K31)-COUNTIF(C31:K31,0).
If there can be no 0 then you don't need the second part.
John
