+ Reply to Thread
Results 1 to 5 of 5

Looking for a formula to calculate the total of several items automatically

  1. #1
    Registered User
    Join Date
    03-27-2024
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1

    Looking for a formula to calculate the total of several items automatically

    Hi guys,
    I run a small store and started working with a new supplier. They send me their item lists in Google Sheets. Is there a formula that'll help me calculate the total number of sold items per month automatically so I can see how many items were sold as I fill out the table? It'd be great if I can also see the total for any item on the list separately, not just overall total.
    A bit off topic, but maybe someone could also recommend a decent cloud backup service - I've run out of space on Google cloud and want something with extra layer of security because I have plenty of videos and photos of products that I take and edit myself.
    Many thanks in advance for your tips.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Looking for a formula to calculate the total of several items automatically

    Is there a formula? Yes, but there is not enough information in your post to create one.

    To have a formula that calculates the number of sold items, you have to have the raw data for your sales. The only thing you have told is about is a list of items. Do you have your own separate sheets in Google Sheets? What does "fill out the table" mean? What table, what data is in the table, how do you fill it out? We need a lot more information, and may need a sample file depending on how complicated this gets.

    For your second question please open a separate thread in The Water Cooler rather than piggybacking an off-topic question here.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Banned User!
    Join Date
    03-11-2024
    Location
    usa
    MS-Off Ver
    CURRENT
    Posts
    23

    Re: Looking for a formula to calculate the total of several items automatically

    You can just add a column for the monthly sales of each item, something like =SUM(B2:B30) to get the total for the month, having B2:B30 be your range of cells. If you would like to sum up any one item's total, you can use the SUMIF function. For example, if you want to find the total of "Item Name," then =SUMIF(A2:A30, "Item Name", B2:B30).
    As for the cloud backup service, if you're looking for something with an extra layer of security and a bit more space, <deleted> cloud-to-cloud backup for Google Workspace might be something to look into. I heard it's good stuff and may be a decent option. Here's their website if you want to take a look: <deleted>
    Last edited by 6StringJazzer; 03-31-2024 at 08:00 PM.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Looking for a formula to calculate the total of several items automatically

    We do not allow links to external commercial sites. It is considered advertising. There are too many cloud backup services available to just recommend a single one.

  5. #5
    Registered User
    Join Date
    04-01-2024
    Location
    sydney
    MS-Off Ver
    2019
    Posts
    9

    Re: Looking for a formula to calculate the total of several items automatically

    Where is the data sample ??

+ 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: 6
    Last Post: 01-24-2024, 06:27 PM
  2. [SOLVED] Using Calculated Items to calculate percentage of total
    By Excellobizzaro in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-13-2023, 09:16 AM
  3. Need formula to calculate items sold x items= profit
    By MaryLouJW in forum Excel General
    Replies: 1
    Last Post: 08-01-2019, 11:14 PM
  4. [SOLVED] How to Calculate Group Total Automatically
    By kprabhupaul in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-24-2016, 01:47 PM
  5. [SOLVED] Calculate the total of a unique item and place in column G and make remaining items 0
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-05-2015, 04:00 PM
  6. Replies: 1
    Last Post: 11-05-2015, 03:18 PM
  7. How to set auto function for grand total to calculate automatically
    By sham159 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-16-2014, 09:58 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