+ Reply to Thread
Results 1 to 4 of 4

I now need to only sum the date for this formular

  1. 02-16-2012, 01:17 AM #1
    watt4
    watt4 is offline
    Registered User
    Join Date
    02-16-2012
    Location
    Brisbane Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    I now need to only sum the date for this formular

    =SUMIF('LAB-41-11311.01-EX'!C:C,'Data Summary'!B153,'LAB-41-11311.01-EX'!G:G)+SUMIF('LAB-41-11311.01-EX'!C:C,'Data Summary'!B154,'LAB-41-11311.01-EX'!G:G)
    This is the formular so far. I now need to sum only the dates for each month and have it change for each month?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-16-2012, 01:53 AM #2
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,655

    Re: I now need to only sum the date for this formular

    I wonder if you've posted a wrong file?
    Quang PT
    Reply With QuoteRegister To Reply
  3. 02-16-2012, 02:23 AM #3
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: I now need to only sum the date for this formular

    hello

    in your uploaded file,
    i'm just assuming you want to sum all (column H ) that meets Column B ( by month )


    look at row 44 down...

    Book2copy.xlsx
    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
    Reply With QuoteRegister To Reply
  4. 02-16-2012, 05:52 PM #4
    watt4
    watt4 is offline
    Registered User
    Join Date
    02-16-2012
    Location
    Brisbane Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: I now need to only sum the date for this formular

    Than you that is very helpful.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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