Results 1 to 3 of 3

Counting if results across rows on another sheet?

Threaded View

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

    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

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