+ 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
    10

    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
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel2016
    Posts
    1,958

    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)
    Bo

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

    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)

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