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!
Last edited by joencrystal; 06-19-2019 at 05:42 PM.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks