+ Reply to Thread
Results 1 to 2 of 2

need help with countif and vlookup

  1. #1
    Registered User
    Join Date
    02-02-2023
    Location
    Bandung
    MS-Off Ver
    2016
    Posts
    1

    need help with countif and vlookup

    I've been trying to use countif and vlookup for my sheet.
    So i've attached a sample, there's 2 sheet on it, work sheet and wage sheet. What i've been trying to do is use count to automatically input the "Total" cell based on the number and type of work from a certain individual.

    Any help is greatly appreciated.
    Sorry for my english btw.
    Attached Files Attached Files

  2. #2
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: need help with countif and vlookup

    worksheet or tab name : Wage Sheet
    Cell C2 formula , Drag down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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] Vlookup, sum, countif
    By LeeBillington in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-19-2018, 11:30 AM
  2. [SOLVED] Need Help with Vlookup + Countif
    By Rajesh CR in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-28-2016, 11:51 AM
  3. [SOLVED] Countif And or Vlookup And help
    By Blake 7 in forum Excel General
    Replies: 6
    Last Post: 01-26-2015, 08:12 AM
  4. I need help with countif and... i'm not sure - VLookup maybe?
    By jimmisavage in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-01-2014, 08:07 AM
  5. [SOLVED] VLOOKUP COUNTIF help?
    By sowdani in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-23-2014, 10:49 AM
  6. Help with Vlookup and COUNTIF (I think)
    By Antlarin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-10-2013, 10:41 AM
  7. [SOLVED] Vlookup & Countif help
    By sumonrezadu in forum Excel General
    Replies: 6
    Last Post: 01-25-2010, 09:27 AM

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