+ Reply to Thread
Results 1 to 3 of 3

returning totals line in sheet with extra empty columns and rows

  1. #1
    Registered User
    Join Date
    04-20-2017
    Location
    Fort Collins, Colorado
    MS-Off Ver
    Office 2010
    Posts
    2

    returning totals line in sheet with extra empty columns and rows

    I need a formula that will search column A for the letters "TTL Emp" and return the number next to these letters and the row that is two rows below. And do this for all of the lines that have TTL Emp in column A. Not sure it may need to be a macro. That way I can then do a sum off all the regular hour and OT columns for control totals.
    Attached Files Attached Files

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: returning totals line in sheet with extra empty columns and rows

    =sumif($a$1:$a$716,$a$31,h$3:h$718)

  3. #3
    Registered User
    Join Date
    04-20-2017
    Location
    Fort Collins, Colorado
    MS-Off Ver
    Office 2010
    Posts
    2

    Re: returning totals line in sheet with extra empty columns and rows

    This formula is close but not quite there. I need the entire row returned and the employee number (next to TTL Emp)

    I have attached an example of what I need it to return. see A522 for my example

    Hopefully this makes it clear.. Thank you!
    Attached Files Attached Files

+ 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. Converting rows to columns and adding extra rows as required
    By teco in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-09-2016, 04:18 PM
  2. [SOLVED] Move data on duplicate rows (different columns) to one row and delete extra rows?
    By Sagwa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2014, 08:25 AM
  3. extra line is added when saving from userform to sheet
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2013, 03:53 PM
  4. Replies: 8
    Last Post: 08-27-2012, 04:37 PM
  5. take extra columns of rows and move to new line
    By rampart551 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-20-2011, 10:01 PM
  6. Copying rows from sheet where cells in specific columns are empty
    By wishmaker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2010, 10:11 AM
  7. Replies: 3
    Last Post: 03-20-2005, 12:06 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