Results 1 to 5 of 5

Excel - SUMIF/COUNTIF multiple columns

Threaded View

  1. 06-16-2014, 03:22 AM #1
    heatwave
    heatwave is offline
    Registered User
    Join Date
    08-08-2005
    Posts
    76

    Excel - SUMIF/COUNTIF multiple columns

    I have a table of data with 5 columns, I need a summary which involves only columns 2 to 5.

    I have tried various COUNTIF/SUMIF and its driving me a little crazy at the moment. I know I am close but not quite there yet

    Attached is the spreadsheet with the data sample with the result format wanted below the table
    Attached Files Attached Files
    Last edited by heatwave; 06-16-2014 at 08:27 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SUMIF, COUNTIF with multiple criteria
    By montreal1775 in forum Excel General
    Replies: 5
    Last Post: 03-05-2010, 12:14 PM
  2. Sumif/Countif using Multiple Criteria
    By blueyz829 in forum Excel General
    Replies: 5
    Last Post: 11-02-2009, 03:25 PM
  3. Countif or Sumif with multiple criteria
    By Eladamri in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-22-2006, 07:45 AM
  4. [SOLVED] multiple criteria with countif or sumif
    By Renee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2006, 09:05 AM
  5. SUMIF in multiple columns based on other criteria in Excel?
    By Scott Powell in forum Excel General
    Replies: 9
    Last Post: 04-13-2005, 10:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1