+ Reply to Thread
Results 1 to 3 of 3

Complex Count Function

  1. #1
    Registered User
    Join Date
    08-08-2008
    Location
    ny
    MS-Off Ver
    365 version 2402
    Posts
    75

    Complex Count Function

    Hello everyone, I am trying to pull a count of items in a column. I have attached a sample to help we talk through this. The logic would be something like show me a count of all the rows in a area where items in column are are equal to value and items in column c are equal to value 2.

    I know you can do a couple steps to get the results but I was wondering if there is a way to combine them both.

    Thanks,

    Stephen
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Try this formula in G3, copied down:

    =SUMPRODUCT(($A$2:$A$30=$F3)*($C$2:$C$30=G$2))
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    08-08-2008
    Location
    ny
    MS-Off Ver
    365 version 2402
    Posts
    75
    That worked beautifully.

    Thank You,

    Stephen

+ 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. How to display help text in the Insert function wizard (Excel)
    By sudhakard in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2009, 11:01 AM
  2. Sort & Count Records?
    By deepak_gl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-17-2008, 11:04 AM
  3. Function for complex count
    By reloader in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-20-2008, 06:13 AM
  4. How to use the count function in a macro
    By PaBowSniper in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-25-2008, 09:54 AM
  5. Count duplicate combinations in 2 columns
    By s80NL in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2007, 10:10 AM

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