Results 1 to 6 of 6

Thread: Request 'Sum-by-week-number' on simple spreadsheet.

  1. #1
    Neophyte JETA's Avatar
    Join Date
    Jan 2020
    Posts
    3
    Articles
    0
    Excel Version
    2013

    Request 'Sum-by-week-number' on simple spreadsheet.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    My knowledge of Excel is limited to simple formulas, but I'm trying to start a very basic spreadsheet to track the cost of groceries per week. I attempted a "sum-by-week-number" formula that was entered into SHEET1, cell B3, but it's flawed....I'm unable to resolve it no matter what I try. I can see the forum deals with issues a lot more complex, but I'm hoping someone might consider briefly assisting me with this. I've attached two files that show SHEET1 (formula), and SHEET2 (data entry). Hoping they're readable.

    Click image for larger version. 

Name:	Grocery-Sheet1-Formula.jpg 
Views:	10 
Size:	61.4 KB 
ID:	9571Click image for larger version. 

Name:	Grocery-Sheet2-DataEntry.jpg 
Views:	13 
Size:	73.1 KB 
ID:	9572

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    204
    Articles
    0
    Excel Version
    2019
    Pictures
    Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.


    1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.


    2. Make sure that your desired results are also shown (mock up the results manually).


    3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).


    4. Try to avoid using merged cells as they cause lots of problems.


    Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

  3. #3
    Seeker mAdMaCCa's Avatar
    Join Date
    Jan 2020
    Posts
    5
    Articles
    0
    Excel Version
    Home & Business 2016

    Lightbulb

    Hi Jeta

    If I have understood your project and problem correctly, I think the attached will do what you need.

    You may need to tweak it to suit exactly what you are after since I have used a single sheet instead of two, but it works.

    Hope it works how you wanted it. Good luck
    Attached Files Attached Files

  4. #4
    Neophyte JETA's Avatar
    Join Date
    Jan 2020
    Posts
    3
    Articles
    0
    Excel Version
    2013
    Thank you both for your response. I'll try the attached formula...attempt to tweak and see if it works. If not, I'll definitely provide more appropriate attachments as recommended. Greatly appreciated.

  5. #5
    Neophyte JETA's Avatar
    Join Date
    Jan 2020
    Posts
    3
    Articles
    0
    Excel Version
    2013
    I followed your example...reverting back to one sheet to keep it as simple as possible...then adjusted the suggested formula as needed and it worked perfectly! This is just a simple family grocery spreadsheet but Excel is still amazing to me. Thank you very much for your help!

  6. #6
    Seeker mAdMaCCa's Avatar
    Join Date
    Jan 2020
    Posts
    5
    Articles
    0
    Excel Version
    Home & Business 2016
    You are welcome, glad I could help ��

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •