+ Reply to Thread
Results 1 to 2 of 2

Can you use CONCANTENATE and SUMIF functions this way?

  1. #1
    Registered User
    Join Date
    11-06-2009
    Location
    Arizona
    MS-Off Ver
    Excel 2003
    Posts
    26

    Exclamation Can you use CONCANTENATE and SUMIF functions this way?

    Hello!

    I'm having trouble building a formula utilizing the CONCANTENATE and SUMIF functions to count the hours completed (red text) only if a date is populated. Attached is the document and screenshot showing my formula. Any help is very appreciated!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by joencrystal; 06-19-2019 at 05:42 PM.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,596

    Re: Can you use CONCANTENATE and SUMIF functions this way?

    you can do it with an ampersand like so... =SUMIF(C6:C60,">1/1/1900",B6:B60)&" Hours Completed"
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ 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. [SOLVED] Confused using the IF and COUNTIF functions (New to Functions)
    By HyperSec in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-11-2016, 12:38 PM
  2. VLOOKUP and IF functions or COUNTIF and AND functions?
    By MHayward in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-02-2015, 11:11 AM
  3. Concantenate cells using criteria or several if functions
    By Bpd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-22-2014, 05:26 PM
  4. Formula with Concantenate
    By gmagerr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-23-2013, 04:30 PM
  5. Concantenate delivers a zero value
    By Russti in forum Excel General
    Replies: 1
    Last Post: 06-04-2010, 12:07 PM
  6. Concantenate Help
    By Terri in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-31-2006, 02:00 PM
  7. concantenate formula?
    By billygalkowski in forum Excel General
    Replies: 3
    Last Post: 12-19-2005, 04:25 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