Closed Thread
Results 1 to 2 of 2

SUMIFS on multiple lines

  1. #1
    Registered User
    Join Date
    07-20-2014
    Location
    phoenix,az
    MS-Off Ver
    200
    Posts
    22

    SUMIFS on multiple lines

    I am trying to use SUMIFS to total only lines that have two named values that are met.


    Looking to only total from data if "SHOP1" and "*any date shown*" to give me a total for the sales dollars.

    Something like =SUMIFS(Sheet4!AI:AI,Sheet4!C:C,"*shop1*",Sheet4!H:H," ")

    Sales dollars are in column AI, shop name is in column C, and "*any date*" in H. Can't quite get this to work. What am I doing wrong?

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: SUMIFS on multiple lines

    Duplicate thread.

    Thread Closed.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 02-06-2015, 08:44 PM
  2. Sumifs with multiple criteria in multiple columns
    By Ganesh7299 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-30-2013, 01:30 AM
  3. [SOLVED] Sumifs with multiple lookups with multiple results to lookup other values
    By malisesaucier in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-10-2013, 01:13 AM
  4. Replies: 2
    Last Post: 01-23-2013, 06:25 AM
  5. SUMIFS Puzzle - Trying to avoid adding multiple SUMIFS to get valid result
    By haldavid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2013, 03:42 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