+ Reply to Thread
Results 1 to 3 of 3

Counting if results across rows on another sheet?

  1. #1
    Registered User
    Join Date
    08-04-2010
    Location
    United States
    MS-Off Ver
    Office 365 for windows
    Posts
    45

    Question Counting if results across rows on another sheet?

    Hello. Help would be deeply appreciated. I've tried a variety of things and formulas to get things to work but I am not having success at all. I've cleared everything out and I'm ready for help

    In my spreadsheet, I have people's names in a table on a sheet named 02 February . Starting at B2 and going downward their names may be duplicated many times for shifts they worked. The column name is EmployeeName.

    Across from them in columns BE through BN are dollar amounts of money they put into a safe.

    I have an info tab and on it, each person's name is entered in a column, listed downward starting in G7.

    I need to find each instance of each person's name on the 02 February sheet in Column B or the EmployeeName Column, read the amount of each safe drop they did across from their name in columns BE through BN, and count the number of times one of the dollar amounts exceeded 200.00 and place that number starting in column I starting at I7 on the Info Sheet. The counted number of times the drops exceeded 200 should correspond with their names in G7 on the Info sheet.
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,841

    Re: Counting if results across rows on another sheet?

    Try in I7:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-04-2010
    Location
    United States
    MS-Off Ver
    Office 365 for windows
    Posts
    45

    Re: Counting if results across rows on another sheet?

    Quote Originally Posted by bebo021999 View Post
    Try in I7:
    Thank you! This works perfectly. I was looking at index match and all kinds of crazy things. Thank you so much.

+ 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. Counting rows with active sheet problem
    By Rob K in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-27-2015, 12:08 PM
  2. Replies: 1
    Last Post: 05-21-2014, 04:02 PM
  3. [SOLVED] copy rows from one sheet to another based formula results
    By cmeunier1973 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-12-2014, 08:52 PM
  4. Replies: 6
    Last Post: 02-04-2012, 06:57 PM
  5. [SOLVED] Keyword search, copy rows to new sheet. Results far from consistent
    By Smatths in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-01-2011, 11:11 AM
  6. Look at last 7 rows in worksheets, put results to sheet 1
    By xmmx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2011, 08:32 AM

Tags for this Thread

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