Results 1 to 10 of 10

sum in matrix if conditions

Threaded View

  1. #1
    Registered User
    Join Date
    06-14-2012
    Location
    Italy
    MS-Off Ver
    Excel 16.0
    Posts
    42

    sum in matrix if conditions

    Hi, I'm trying to sum (numeric) content of matrix if 1st colum is into a certain range.
    I was able to do it with letters (e.g. sum if 1st column is A or B) but not with numbers (e.g. sum if 1st column is between 10 and 17)

    I'm attaching the very simple file I'm working on..can you please help? table is on the right (then I also have a question for that on the left but I'll save it for later).

    Thanks!
    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] Average of matrix elements using row and column conditions
    By Luis Ah-Hoy Jr. in forum Excel General
    Replies: 3
    Last Post: 06-09-2017, 10:42 AM
  2. Copy certain cells based on matrix conditions
    By etaver in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2017, 11:37 AM
  3. deleted post
    By joemac92 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-10-2015, 12:19 AM
  4. Multiple conditions with matrix table
    By redjess555 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-01-2015, 09:20 AM
  5. Filling matrix depending on conditions
    By sharpxs in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2014, 06:06 AM
  6. Dynamic Comparitive Matrix Table with Data validation conditions
    By santhosh51 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-08-2013, 09:21 AM
  7. Replies: 1
    Last Post: 07-08-2013, 09:20 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