Results 1 to 10 of 10

Dynamic Count and Sum Array Formulas Based on Multiple Conditions

Threaded View

  1. #1
    Registered User
    Join Date
    11-10-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    42

    Dynamic Count and Sum Array Formulas Based on Multiple Conditions

    Guys,

    I looking for a Dynamic Count and Sum array formulas to count and sum the unique values based on 2 conditions similar to what the Remove Duplicates Function in the Excel Ribbon. Col. B will contain number values only and Col. C will contain Text & Numeric combined.

    Both array formulas should adjust to variable ranges. Each formula should be placed in its corresponding
    cell as highlighted in yellow. Attached is the XL file as an example.

    Highlighted in yellow is what the result of the dynamic count and sum array formulas should return as the answer.

    Thank you,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count multiple conditions array only worked with 1 value
    By bob33 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-19-2013, 05:10 PM
  2. [SOLVED] Count multiple conditions array only works with 1 value
    By bob33 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-19-2013, 12:57 PM
  3. Array formula to count based on multiple conditions
    By markrennolds in forum Excel General
    Replies: 1
    Last Post: 11-09-2010, 05:56 PM
  4. [SOLVED] Total or Count based on multiple conditions
    By CC in forum Excel General
    Replies: 4
    Last Post: 05-17-2006, 05:55 PM
  5. Replies: 1
    Last Post: 08-25-2005, 03:43 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