+ Reply to Thread
Results 1 to 3 of 3

SUMIF Rows and Columns Not working

  1. #1
    Forum Contributor
    Join Date
    08-13-2014
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    209

    SUMIF Rows and Columns Not working

    1 A B C D E F G H I J
    2 M M M M M T T T T
    3 12PM 1PM 2PM 3PM 4 PM 12PM 1PM 2PM 3PM
    4 12 .5 0 .5 .5 .5 0 0 0 0
    5 13 .5 .5 .5 .5 .5 0 0 0 0
    6 14 0 0 0 0 .5 .5 .5 .5 .5
    7 21 .5 .5 .5 .5 .5 .5 .5 .5 .5
    8 22 0 0 0 0 0 0 0 0 0
    9 23 .5 0 .5 0 .5 0 .5 .5 .5
    10 24 0 0 0 0 0 0 .5 .5 .5
    11 31 .5 0 0 0 .5 .5 .5 .5 0


    Good morning,

    I have the following table and I can trying to use this formula to no avail:

    Formula:
    Please Login or Register  to view this content.
    Thanks for the help!

    M

  2. #2
    Forum Contributor stephenloky's Avatar
    Join Date
    07-10-2013
    Location
    Sao Paulo - Brazil
    MS-Off Ver
    Excel 2007
    Posts
    146

    Re: SUMIF Rows and Columns Not working

    Can you post a sample workbook? Can't you make a pivot table to count that?
    "The quieter you become, the more you are able to hear"

    Any reputation (*) points appreciated.

    "If you know yourself but not the enemy, for every victory gained, you will suffer defeat."

  3. #3
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: SUMIF Rows and Columns Not working

    Hi,

    a possible approach

    =SUMPRODUCT(B4:J1000,(B2:J2="M")*(B3:J3="1PM")*(A4:A1000=23))

    Hope it helps
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

+ 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. Sumif or Sumproduct with Multiple Rows & Columns
    By vulches in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-12-2017, 02:06 AM
  2. Unable to SUMIF across columns and rows
    By sandy.rogers in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-21-2012, 09:11 AM
  3. How do I Sumif a date range using ROWS not COLUMNS
    By Thito in forum Excel General
    Replies: 1
    Last Post: 05-03-2012, 02:40 AM
  4. Increment Rows Across Columns in copied SUMIF formula??
    By Chizilla in forum Excel General
    Replies: 3
    Last Post: 02-10-2010, 05:56 PM
  5. SUMIF with rows and columns
    By David Howdon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-17-2005, 01: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