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!!
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.
Nope!, will have to try something else unless you can give me a tutorial on attaching worksheets which I have done several times before!!!
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