Formula for subtotals by product in lists where the number of rows per product varies RRS feed

  • Question

  • I have daily lists of products sold where the product names are listed alphabetically but the number of rows per product name varies day-to-day. I want to subtotal the number of each product sold that day.
    Monday, October 17, 2016 8:42 AM

All replies

  • Hi,

    How do you design your table or the daily lists?

    Does it look like:

    Please share more detail information about your data. Like products are in column #, Date is in column A.

    You could share us screenshots here, a sample document with data would be more helpful.



    Tuesday, October 18, 2016 2:43 AM