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)
Last edited by Artie01; 03-24-2021 at 03:16 AM.
Re: Error Uploading to Google Drive with Sumproduct function (Sumif across multiple sheets
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:
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Shankar2021 in forum Excel Programming / VBA / Macros
Last Post: 03-15-2021, 02:12 AM
By sbv1986 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
Last Post: 03-01-2021, 10:47 PM
By western in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
Last Post: 01-18-2021, 01:31 PM
By western in forum Excel Programming / VBA / Macros
Last Post: 01-14-2021, 08:48 AM
By thenormanizer in forum Excel General
Last Post: 06-21-2017, 06:32 PM
By Jim_Johnson in forum Excel General
Last Post: 02-12-2015, 04:58 PM
By formulaic in forum Excel Formulas & Functions
Last Post: 08-17-2012, 02:02 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1