I was using this before and it worked great. Now it is not. getting error #DIV/0!Please Login or Register to view this content.
I am not sure how or why.
Any ideas?
I was using this before and it worked great. Now it is not. getting error #DIV/0!Please Login or Register to view this content.
I am not sure how or why.
Any ideas?
Hard to say without seeing a sample of your data, but are you sure your numbers/values are actually numbers, and not text? test with =isnumber()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
That would indicate that you do not have any numbers in Sheet10!C2:C7 that are >0
Does it look like you do? The "numbers" may be formatted as text in which case AVERAGEIF won't recognise them
Audere est facere
I changed Collumn C from general to number. No change
I also tried this, again, no change.
I can not provide the actual document as it is to large. Sheet9 pushes the info to sheet10. Sheet 9 and 10 appropriate rows are listed as numbers, not generalPlease Login or Register to view this content.
Ok, you were right it is coming through as text. Apparently there was an error I didn't pay attention to on the column. So switching from general to a number did nothing. Any idea how to make that rome permanently be a number not text. Auto convert?
Changing the format will not change the contents of a cell, just it's appearance. Where is the data coming from inthe 1st place?
sheet 9 it than pushes to 10 with a Marcos code.
Last edited by dohara; 04-29-2014 at 01:57 PM.
Please Login or Register to view this content.
Change the format of column from text to General. Then select the range then press F2 and then press Ctrl+Enter.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks