+ Reply to Thread
Results 1 to 2 of 2

Sum data based on multiple criteria across multiple columns

Hybrid View

  1. #1
    Registered User
    Join Date
    05-31-2011
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    2

    Sum data based on multiple criteria across multiple columns

    I apologize if there's a similar question in the forum already but I wasn't able to find it if there is.

    I have a spreasheet for my business where I list my clients and all the payments I receive from them.

    Column A - Date

    Column E - Payment 1 Date
    Column F - Payment 1 Amount
    Column G - Cash, Check, or Credit

    Column H - Payment 2 Date
    Column I - Payment 2 Amount
    Column J - Cash, Check, or Credit

    I'm trying to create a summary tab where it will automatically calculate the total that I've received in Cash, Check, and Credit by month. I'd like it to look like....

    summary.png

    I cannot seem to figure out the right formula to use.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,605

    Re: Sum data based on multiple criteria across multiple columns

    Perhaps use a Pivot Table?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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