+ Reply to Thread
Results 1 to 2 of 2

Error Uploading to Google Drive with Sumproduct function (Sumif across multiple sheets)

  1. #1
    Registered User
    Join Date
    03-06-2021
    Location
    Indonesia
    MS-Off Ver
    2007
    Posts
    5

    Error Uploading to Google Drive with Sumproduct function (Sumif across multiple sheets)

    Hi, I have an excel formula that returns SUMIF across multiple sheet. It works fine in excel, but return only value of first sheet when uploaded to google drive.

    Can someone tell me what is wrong?

    I have tried to make the formula in the google sheet directly but to no avail (only return value for the first sheet)

    Thanks

    excel1.PNG

    excel2.PNG

    excel3.PNG
    Attached Files Attached Files
    Last edited by Artie01; 03-24-2021 at 03:16 AM.

  2. #2
    Forum Contributor
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    MS 365
    Posts
    171

    Re: Error Uploading to Google Drive with Sumproduct function (Sumif across multiple sheets

    Hi Artie01,

    Not sure how to accomplish what you want using SUMPRODUCT, but here is a way of doing it using a query in Google sheets. The query is in cell A1 on Sheet 1. Hope this helps. This is the link:

    https://docs.google.com/spreadsheets...it?usp=sharing

+ 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. uploading files & downloading files in google drive from excel VBA application
    By Shankar2021 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2021, 02:12 AM
  2. Google sheet: Help to attachment file from Google Drive and send email fill in Google Form
    By sbv1986 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-01-2021, 10:47 PM
  3. [SOLVED] Google sheets script to download file and save it to google drive folder and use it's data
    By western in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 01-18-2021, 01:31 PM
  4. [SOLVED] Google sheets vba to download file and save it to google drive folder and use it's data
    By western in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2021, 08:48 AM
  5. Replies: 2
    Last Post: 06-21-2017, 06:32 PM
  6. Uploading an Excel File with Macros in Google Sheets
    By Jim_Johnson in forum Excel General
    Replies: 1
    Last Post: 02-12-2015, 04:58 PM
  7. Replies: 0
    Last Post: 08-17-2012, 02:02 PM

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