Hi All
I have a string of numbers in cells E4:Z4, i want cell AH to count the number of Whole numbers
Have found various answers to this on this and other forums but seem to always get #VALUE errors
Thanks
Ian
Hi All
I have a string of numbers in cells E4:Z4, i want cell AH to count the number of Whole numbers
Have found various answers to this on this and other forums but seem to always get #VALUE errors
Thanks
Ian
Hi ian,
welcome to the forum...
It will be helpful, if you can post the URL where you exactly facing error.. or a sample file..
in the meanwhile.. try this.. Array Formula..
Formula:Please Login or Register to view this content.
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
this will work IF the decimal is indicated with "." (eg: 2.2 ) it will return error when using "," (eg: 2,2)
Please Login or Register to view this content.
If solved remember to mark Thread as solved , to mark your thread as Solved select Thread Tools and click Mark thread as Solved.
I can't read the mind of my wife so then I get picture but no sound .... and then I mostly get the idea, same goes here picture your outcome and I get the idea.
Hi,
Perhaps you could share with us the solutions which you've already tried? Without seeing the format of your data, it's difficult to be sure of a solution, but perhaps:
=SUM(IFERROR(--(MOD(E4:Z4,1)=0),0))
Note: must be array-entered
Regards
@Debraj Roy, hulpeloos
What if some of the entries are non-numeric?
Regards
Thank you, I still get the #value error (even after a CTRL-SHFT-ENTER)
How do I attach a file? I (hopefully) have attached a screen grab to show what I am trying to do. the red text is actually a number with .001 after it.
ave.PNG
Thanks for the catch & guidance..
Just combining your & XOR LX 's idea..
Formula:Please Login or Register to view this content.
@ XOR LX .. "every case has some what if..
Last edited by Debraj Roy; 09-19-2013 at 09:56 AM.
"@ XOR LX .. "every case has some what if.. ""
Too true, my friend! Too true!
Sorry guys, i'm not sure i have explained myself very well, let me try and go back a few steps...
I am trying to calculate a batting average for a cricketer (or more accurately a league full of them)
Therefore i am trying to calculate "Total Runs / (Total Innings - Not outs)" = Average. I can count innings (cells containing a number) and i want away of inputting not out number so it can be input and the formula counts it differently to subtract it from total innings. DNB is entered to prove the player appeared in a game, but did not bat
Ok.. so can you please re-upload the file.. with some manual inputs.. in Not Out section..
just want to figure out.. how you decide .. a player is "Not put".. and
why few runs are 0.001 and what does a red font denotes..
2014.xlsx
I have left a single row with example data, and descriptions for what function i want each cell to use.
The decimal point 1.001 was just part of my attempt to solve he issue.
Thanks in advance
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks