Results 1 to 3 of 3

Report to sum all customer transactions by month

Threaded View

  1. #1
    Registered User
    Join Date
    03-23-2020
    Location
    Bulgaria
    MS-Off Ver
    2013
    Posts
    1

    Report to sum all customer transactions by month

    Hello everybody, completely new here. I tried searching for a solution many hours and just couldn't find any, so I decided to ask for help.

    So I have monthly reports of my customers and I need to know how much every customer spent in the whole year.

    I imagine that first I would need to create a new sheet and with some unknown formula to me to get all unique customer emails first.
    And then next to it with another unknown formula to sum all the transactions from my original reports with customer email X.

    Can you help me figuring out these two formulas?
    Thanks in advance!

    Administrative Note:
    As per our Forum rules, we ask you provide a clear and descriptive thread title. As you are a new member with one post, I tried to do that for you based on your description.
    Last edited by jeffreybrown; 03-23-2020 at 03:00 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Mark the last three transactions for each customer
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-23-2016, 01:01 AM
  2. Agging report, openingbalance report,customer report vab code was not working
    By rana19 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2015, 03:38 AM
  3. Replies: 4
    Last Post: 08-18-2015, 10:02 AM
  4. How to pull transactions into a template based on a customer code?
    By The_Snook in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2013, 03:34 PM
  5. Replies: 1
    Last Post: 12-14-2012, 05:39 AM
  6. Grouping customer transactions, then sorting. Please help.
    By dolphinprinting in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-19-2012, 11:53 AM
  7. Report - create summary of transactions
    By mperedithe in forum Excel General
    Replies: 1
    Last Post: 10-02-2007, 06:38 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