+ Reply to Thread
Results 1 to 2 of 2

Summing values based on conditions

  1. #1
    Registered User
    Join Date
    02-06-2012
    Location
    NYC, US
    MS-Off Ver
    Excel 2010
    Posts
    19

    Summing values based on conditions

    I have columns called accKey, dateKey, feeType, and item count. There are three types of accounts, seven types of fees, and 200 or so dates each corresponding to an item count. I want to find the total item count for a certain date and fee type. In other words, consolidating the accKey column, so I'm just finding the total item count of a certain type of fee on a specific date regardless of the accKey.

    For example,
    I have a table like this:

    dateKey____AccKey_______FeeType____Total Item Count
    1____________1 ___________2__________10
    1____________2____________2__________10
    1____________3____________2__________10
    2____________1 ___________2__________10
    2____________2____________2__________10
    2____________3____________2__________20
    3____________1 ___________2__________10
    3____________2____________2__________10
    3____________3____________2__________30

    Thus on date 1, the total item count was 30
    Thus on date 2, the total item count was 40
    Thus on date 1, the total item count was 50

    But I want to produce a table like this:
    dateKey_____FeeType____Total Item Count
    1____________2__________30
    2____________2__________40
    3____________2__________50

    How do I do this?

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887

    Re: Summing values based on conditions

    Hi Juliorevka,

    A quick way to get your table would be using Pivot Tables. Select your data including header row (e.g. A1:D100) then click Insert - Pivot Table.

    Drag the DateKey and FeeType fields to the Row Labels area. Drag the Total Item Count field to the Values area.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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