Results 1 to 1 of 1

User input value 0.17 or 0 to the calculation cell of the count row.

Threaded View

  1. #1
    Registered User
    Join Date
    03-26-2018
    Location
    Bucharest, Romania
    MS-Off Ver
    Office2014
    Posts
    1

    User input value 0.17 or 0 to the calculation cell of the count row.

    Hi there!

    I'm working to make a survey which combines Excel with a program to make a survey (Survey123 for Arcgis).
    In my survey i have 6 questions, first, each of this 6 questions has 2 arguments "yes=0.17 is for appling" and "no=0 is for not appling". Next, checking one of these 2 boxes, the value must update to the Count row for the calculation field / survey sheet (see printscreen) with one of the values 0.17 or 0. The yes or no values are defined in Choices sheet. Next in my survey i need to display the weight % of the check answers, using this function ( if(sum( allcounts = 0, "" , count9/sum( allcounts) and here is the problem...i think that the counts are not defined to allow the formula to work.
    =IF(SUM(M9,M19,M28,M37,M46,M53)=0,"",M9/(SUM(M9,M19,M28,M37,M46,M53)))
    survey.jpg
    This is the survey sheet, the field called ( Name ) is gonna be the future database of the survey to add it in a map.

    Choices.jpg
    The choices sheet.

    App.jpg
    The interface of the Survey 123

    Thank you!
    Attached Files Attached Files
    Last edited by DragosD; 03-26-2018 at 11:22 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count specific day between fixed dates, with user input controlling time frame, month/s
    By Joe Bob Crain in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-12-2017, 04:16 PM
  2. Replies: 9
    Last Post: 07-10-2015, 11:34 AM
  3. Count User Input per Row basis and verify = 100
    By Mach7 in forum Excel General
    Replies: 3
    Last Post: 10-16-2012, 11:29 AM
  4. [SOLVED] Count Rows Based On User Input & Trigger Print Of Pages Out Of Count Result
    By wliang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2012, 02:45 AM
  5. Automatically Add/Delete rows based on user input but check current table row count
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-31-2011, 11:39 AM
  6. Automate calculation of output based on user input
    By tenn0228 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-02-2009, 06:24 PM
  7. Have user input converted to uppercase in same cell as input?
    By Shannonn in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-19-2006, 10:25 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1