+ Reply to Thread
Results 1 to 4 of 4

Count specific values in column G, sorted by values in column A

  1. #1
    Registered User
    Join Date
    04-23-2020
    Location
    Washington, DC
    MS-Off Ver
    Office 365
    Posts
    2

    Count specific values in column G, sorted by values in column A

    I'm trying to setup a table that keeps track of Invoices vs. Card purchases organized by location #. I know this will require 2 formulas but have no clue how to set them up. Any direction or assistance would be amazing, as I have been beating my head against a wall for 2 days.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-14-2013
    Location
    Austria
    MS-Off Ver
    2016 / 2019
    Posts
    339

    Re: Count specific values in column G, sorted by values in column A

    For "Invoice" use
    Please Login or Register  to view this content.
    At the beginning it did not work because the header was Invoices

    see attached file
    cheers
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-23-2020
    Location
    Washington, DC
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Count specific values in column G, sorted by values in column A

    Thank you so much! Now that I have the example, I can play around and learn from it as well

  4. #4
    Valued Forum Contributor
    Join Date
    01-14-2013
    Location
    Austria
    MS-Off Ver
    2016 / 2019
    Posts
    339

    Re: Count specific values in column G, sorted by values in column A

    welcome

+ 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. Match sorted column values with unsorted column values
    By akshay6s in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-29-2019, 09:20 AM
  2. [SOLVED] How to count unique distinct values from a column where values in other column exists ?
    By Daniel Tou in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-19-2017, 05:48 PM
  3. Count values in a row pertaining to a specific date range column
    By MattStolz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-23-2015, 03:21 PM
  4. find and then count values in a specific column
    By mubashar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2014, 03:53 AM
  5. Count column w/blanks & values based on specific date
    By nickelcell1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-30-2009, 04:08 PM
  6. How do I total only specific values in a column based on the values in another column
    By Needy McHelpson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-23-2009, 12:17 PM
  7. Count specific text values contigent on value in next column
    By rgarber1950 in forum Excel General
    Replies: 2
    Last Post: 05-21-2008, 11:23 PM

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