Trying to count these cells.
=sum(J7:J18) states number two, but also says something is wrong
=count...... same problem
*** Watch the unfilled cap between result and column
JAN FEB MRT APR MEI
JAN 0 MRT APR MEI
JAN 0 MRT APR MEI
JAN 0 MRT APR MEI
JAN 0 MRT APR MEI
JAN 0 MRT APR MEI
JAN 0 MRT APR MEI
JAN 2 MRT APR MEI
JAN 0 MRT APR MEI
JAN 0 MRT APR MEI
JAN 0 MRT APR MEI
0 #NAME? 0 0 0
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
tellen.xls
here's part of the file
thanks
e19 says =sum(J5:J18)
J5:J18 is all text you cant sum text
=counta(J5:J18) gives 10
bt why have you got that under feb? which is col e
Beste Harrij, dear Harrij
Is this how you data is built up?
Why you have all columns filled with the name of the month?
What is the use for that?
Maybe your looking for this one?
DutchEnglish
Please Login or Register to view this content.I see Martindwilson has already given you this answerPlease Login or Register to view this content.
Last edited by oeldere; 02-09-2013 at 06:25 AM.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
counta/AANTALARG doesn't have a second arguement
sorry copied pieces through network so cells are off.
It is shown in Column E ( Februari )
=sum(E5:E18) ...... gives error
I have a VBA Excel running.
Because its was necessary ti fill the cells first with name of month and later in the script ,the name of month was replaced by a number.
So then I needed to sum the total errors in that specific column.
Result is still not well, because there are also some blank cells I guess. Skipping these blank cells and setting the Result= straight under the last number works alright.
So I need to pass the empty cells.
MartindWilson of course your totaly right.Please Login or Register to view this content.
Please Login or Register to view this content.Please Login or Register to view this content.
however when i open that workbook e19 says #name but when i re enter it changes ok
I get the same error as Martin does initially.
Are you using a Dutch version of Excel?
Maybe you should try SOM() instead of SUM()
As oeldere, asked earlier, why are your columns mainly just months repeated? What is the point of this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks