+ Reply to Thread
Results 1 to 3 of 3

Trying to record stock used on a shared Google spreadsheet

  1. #1
    Registered User
    Join Date
    06-09-2017
    Location
    Reading
    MS-Off Ver
    365
    Posts
    19

    Trying to record stock used on a shared Google spreadsheet

    Hi

    I have a Summary sheet, whereby I'm trying to keep an accurate stock update from my company store. I'm building this in a shared Google spreadsheet that I can share with my team.
    I have managed to return the stock used for the first row of data, but although I think I'm referencing additional rows (down to 26), the formula isn't picking up the amounts from the next row. I've downloaded the document into regular Excel so I can attach it here, but that does seem to have the effect of breaking some stuff.....but please look at the screenshots attached.....can anyone see what I'm doing wrong, so that the formula doesn't recognise the 2nd row (and subsequent rows) of data?

    Many thanks
    Gemma
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by 6StringJazzer; 11-02-2018 at 07:19 AM. Reason: Moved from Excel Formulas & Functions because formula is specific to Google Sheets

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Trying to record stock used on a shared Google spreadsheet

    Please try

    C3
    =SUMPRODUCT(--('Event Planner'!$E$3:$I$26=A3),'Event Planner'!$F$3:$J$26)

  3. #3
    Registered User
    Join Date
    06-09-2017
    Location
    Reading
    MS-Off Ver
    365
    Posts
    19

    Re: Trying to record stock used on a shared Google spreadsheet

    That works! Thank you very much!
    Gemma

+ 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. Replies: 2
    Last Post: 04-05-2016, 01:48 AM
  2. automatic hyperlink to each item in stock for its google images
    By sterio in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2015, 09:38 AM
  3. hyperlink to each item in my stock in google images
    By sterio in forum Excel General
    Replies: 0
    Last Post: 04-23-2015, 06:11 AM
  4. [SOLVED] Five individualy link-shared Google Sheets into One-how
    By Red fuji in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 02-13-2015, 12:18 PM
  5. Getting live stock quotes from Google Finance from Indian stock exchanges like NSE and BSE
    By nischalshetye in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2014, 06:21 AM
  6. Realtime Stock quote from Google Finance and charting
    By kaleem1919 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-21-2014, 06:11 AM
  7. 7 Hour Countdown Clock in and Excell Shared Google Doc
    By Steamys in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 06-19-2014, 09:41 AM

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