Results 1 to 14 of 14

Sum and count formula with multiple column and row

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Sum and count formula with multiple column and row

    hello all,

    i need something simple formula to sum and count my set data excel, with multiple criteria...
    (multiple column and multiple row)....

    here, 4 criteria have matching line row and column (location, model, range of year and level)...

    and then expected sum and count start from in cell D12 down right (col. Y1, Y2, Y3)..

    i am called "green area"

    further information, please see my workbook upload........

    for your helping, i say much appreciated and thanks very much....

    john.m
    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 text in one column Matching single or multiple Criteria from Other Column Excel 2003
    By Jose Macieira in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-17-2013, 06:55 AM
  2. Replies: 2
    Last Post: 07-01-2012, 03:54 AM
  3. a formula to count multiple cells in a column?
    By grimlock in forum Excel General
    Replies: 1
    Last Post: 05-20-2011, 12:22 PM
  4. Formula to Check Column A for date range and count Column B
    By realniceguy5000 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-28-2009, 12:58 PM
  5. Formula to lookup Multiple Column Text and then Count Result
    By ShelbyMan in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 09-06-2005, 07:05 PM

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