In the attached worksheet I have this formula and other similar
Formula:
Please Login or Register to view this content.
If you start putting in values in column C the formula will not register the values until you end up in the same row as the formula. To see what exactly I mean, put a 1 in C1, then C2 and on and watch the formulas. What is a way around this?
Hi.
What precise results are you hoping for, and why?
Regards
I am wanting a count of the number of times 1, 2, and 3 occur and an average of all the 1, 2 and 3s that occur, and if no data has been entered then the text "No Input" would be given instead.
By "no data has been entered" what precisely do you mean? That all of C1:C10 are blank? Or just the entry in column C in the same row is that in which the formula lies?
Perhaps you should yourself add some values to your workbook and include your expected results.
Regards
That all of C1:C10 are blank?
That is the purpose "No Input" should serve. However the formula doesn't seem to recognize there is data in C1:C10 until there is data put in the cell adjacent to it. The latest upload demonstrates this.
Thanks.
You need something like:
=IF(COUNTIF($C$1:$C$10,"<>"),COUNTIF($C$1:$C$10,1),"No Input")
etc.
Regards
The formula worked great, thank you. How would you redo this one?
Formula:Please Login or Register to view this content.
I tried this and it didn't work,
Formula:Please Login or Register to view this content.
The below formula gave me the same issue where it didn't register until the adjacent cell had a value in it.
Formula:Please Login or Register to view this content.
Last edited by Butcher1; 11-11-2014 at 12:00 PM.
Maybe this...
=IF(COUNT(C1:C10),AVERAGE(C1:C10),"No Input")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you, it worked.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks