Morning, I need to convert a column list of text into a number total, i.e. if cells c3,c4,c5,c6 have text in them I want to see a total of 4 in the total cell
Many thanks
Morning, I need to convert a column list of text into a number total, i.e. if cells c3,c4,c5,c6 have text in them I want to see a total of 4 in the total cell
Many thanks
Last edited by birchetts; 03-26-2012 at 07:45 AM.
Hi
Try this
=countif(c3:c6,">0")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Result is 0?, am I doing something wrong?
No! I did...Result is 0?, am I doing something wrong?
=COUNTIF(C3:C6,"<>")
That's got it
Many thanks Fotis
Fotis, how do I edit the thread as [solved]?
What you have given me is exactly what I needed,but progressing from that!, if I now have several columns with the totals as generated by your formula, how do I get the numeric total of those columns, I have just tried to =sum(c10:f10) but it does not give me a numeric total just a text of the formula I have just put in?
Try.
=COUNTIF(C10:f10,"<>")
Rule 9, of the forum.
9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Sorry Fotis it didn't work !!?, in testing all of this, for some reason the 5 columns which I have input the original formula into reflect totals of 1,2,2,4,1 (10) but your formula throws out a total of 5 ? any thoughts?
I can not follow you......
=SUM(C10:F10) This formula works ok.
These are 4 columns. Not 5.
Sum function, adds values
Count(and countif) functions,COunts how many times "something", exists "somewhere"
If you still don't found your solution, then pls.
Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
Fotis, For some reason I just cannot download my sample worksheet, I will send you a personal message and hope that I can attach it there!!
Nope!, will have to try something else unless you can give me a tutorial on attaching worksheets which I have done several times before!!!
OK lets let's try again, and sorry if I am confusing you as you are being very patient and helpful, so, just for example, I have 5 columns, each column has a total which contains your original formula (which works), I now want to add the numeric totals of those 5 columns, you have given me: =COUNTIF(C10:f10,"<>"), but this does not seem to work?, I have input several entries into various cells which amount to 10 entries, these are distributed in no particular number between the 5 columns so in theory your formula should throw out a total of 10, but it doesn't, it throws out 5, and in fact it throws out 5 whether I put 10,15,18,20 or any other number of cell entries. So Fotis, any ideas?, and again thank you very much for persevering with me.
What i do is this.
As i see last post, under the *, i push twice the button that says "+Reply to Thread"
Then in the new window, scroll down and find a button that says "Manage Attachement". Push this twice and follow the intrunctions.
Or else, PM to a Moderator. Maybe he(she) will helps you.
Tried that Fotis, and it's worked before but not this time?, oh well, I hope I have explained in my reply above?
Take a look to the example...
Sorry Fotis I did not concentrate when you responded (response10) re the SUM formula, I just majored on your reply 'these are 4 columns not 5' and immediately tried to send a sample worksheet. In fact the SUM formula works.
Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks