+ Reply to Thread
Results 1 to 10 of 10

Trying to find the sum from a different sheet

  1. #1
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Microsoft 365
    Posts
    215

    Trying to find the sum from a different sheet

    In my google worksheet, I'm trying to find the number of shots on target for Crystal Palace. As you can see, in the Fixtures sheet, cell D2, I am using VLOOKUP to bring the data I need from the SOT sheet. In my example, I want cell D2 to read 19, which is the total number of shots on target recorded by Crytal Palace.
    I'm guessing I need to include the SUM function but I'm still not having any luck coming to the correct solution.

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

    Thank you.
    Last edited by tom hatten; 12-16-2020 at 01:57 PM.

  2. #2
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,133

    Re: Trying to find the sum from a different sheet

    You need to give access to view the document....

  3. #3
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Microsoft 365
    Posts
    215

    Re: Trying to find the sum from a different sheet

    I'm sorry. Is this the correct link?
    https://docs.google.com/spreadsheets...it?usp=sharing

  4. #4
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Microsoft 365
    Posts
    215

    Re: Trying to find the sum from a different sheet

    I think this is the correct link:
    https://docs.google.com/spreadsheets...it?usp=sharing

    Thank you.

  5. #5
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,133

    Re: Trying to find the sum from a different sheet

    In cell D2, try this:

    Please Login or Register  to view this content.
    Last edited by Haluk; 12-15-2020 at 05:03 PM.

  6. #6
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Microsoft 365
    Posts
    215

    Re: Trying to find the sum from a different sheet

    Can I copy across to column D or will adjustments be neccessary? It seems ok but I haven't manually checked.

    Thank you.

  7. #7
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,133

    Re: Trying to find the sum from a different sheet

    I've done for column E also, check your sheet ...

  8. #8
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Microsoft 365
    Posts
    215

    Re: Trying to find the sum from a different sheet

    I've tried, but have been unable to find a way of using your formula in the spreadsheet below. With hindsight, I should have produced the whole sheet in the first place!
    It still isn't complete, as there will be several more leagues to add but I don't see that being a problem.

    The formula would start in cells AR8 and AS8.

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

    Thank you for all your help.

  9. #9
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,133

    Re: Trying to find the sum from a different sheet

    There so many sheets in your document and i'm not sure which one will be used, because you didn't give a clue.

    Check the sheet "Copy of 14" to see my edit.

  10. #10
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Microsoft 365
    Posts
    215

    Re: Trying to find the sum from a different sheet

    It all looks good and I'll mark thread as solved again. If I come across any problems, I'll respectfully let you know.
    Thank you!

+ 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] Bulk Find Number from 2nd Sheet in 1st Sheet and copy value from same row to sheet 2
    By adblog3 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-23-2020, 02:25 AM
  2. Find sheet in different work and find specific value on that sheet
    By jimstrongy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-02-2017, 09:36 AM
  3. Replies: 6
    Last Post: 07-26-2015, 03:43 AM
  4. Replies: 4
    Last Post: 01-28-2014, 01:04 PM
  5. [SOLVED] find code# from sheet 1 on sheet 2, compare value on sheet 1 with value on sheet 2
    By BlakeLee in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-27-2013, 01:52 PM
  6. Find value from sheet 1, cell A1 in sheet(s) 2 (3, 4?), copy, paste row to sheet 8
    By fleeting in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2011, 03:31 PM
  7. Replies: 1
    Last Post: 01-31-2006, 06:25 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