+ Reply to Thread
Results 1 to 2 of 2

SumIF + Large + Array in Google Sheets

  1. #1
    Registered User
    Join Date
    09-13-2021
    Location
    Virginia, USA
    MS-Off Ver
    Google Sheets
    Posts
    1

    SumIF + Large + Array in Google Sheets

    I am working on a Google Sheet to pair with Autocrat in order to create a report based on entries into a Google Form.

    The workflow will be:
    1. Evaluator enters in scores in Google Form (the rubric)
    2. Scores auto-populate in Google Sheet linked to form
    3. Autocrat Add-On generates document report of scores per entry

    There are some unique constraints in the scoring, though.
    For each "Area," we take the "best of two scores."

    For the FINAL score, we take the "total of the best of 3" out of the 4 areas.
    For that cell, I am using
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I finally figured out the "final score" formula, but I need it to be an array formula and auto-populate into all cells in that column. Dragging down to autofill does not work because when a form entry goes into the spreadsheet, it creates a new row above the existing ones, so the formulas won't be present without an array formula.

    AC3 is the sum of the total of the 3 largest scores between K3, R3, W3, and AB3.
    I need AC3 to be an array for the rest of AC, just as I've done in K, R, W, and AB.

    Also, this will not let me attach a link or screenshot of the Sheet...

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: SumIF + Large + Array in Google Sheets

    to attach a screenshot, in the bottom left corner of your post, click "Go Advanced", then select the image file, then click "Upload file (s)", once done it will show the files in a list, and at the bottom you can then click "Close Window", once returned to the post window you can then click to complete the post, and the image will be attached.

    to add a link to google sheets file, put the link into a text file, and attach it in the same method as for an image, using "Go Advanced"

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Google Sheets: SUMIF for 2 negative conditions
    By polgomez in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 07-19-2021, 12:35 PM
  2. array formula for google sheets
    By cyrano3790 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-13-2021, 12:46 AM
  3. Google Sheets: Sumif returns 0?
    By toml90 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 03-28-2021, 08:34 PM
  4. [SOLVED] Google Sheets: COUNTIFS and SUMIF formulas returning 0
    By algoit in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 8
    Last Post: 01-23-2021, 03:28 AM
  5. Google Sheets Array and importrange help
    By ckserra in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-04-2018, 01:59 PM
  6. =SUMIF and LARGE(array,n) HELP
    By minhtran1085 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-29-2016, 06:57 PM
  7. SUMIF with different date formats (Google Sheets)
    By djarcadian in forum Excel General
    Replies: 1
    Last Post: 08-09-2014, 08:16 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