+ Reply to Thread
Results 1 to 4 of 4

Need help with counting how many cell is in another worksheet

  1. #1
    Registered User
    Join Date
    11-06-2015
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    57

    Need help with counting how many cell is in another worksheet

    Hi,
    Here is how our worksheets are layed out.

    Worksheet for Quotes created
    excel-quotes-created-1.png

    Worksheet for Quotes won
    excel-quotes-won-1.png

    What I'm trying to do is find out which of the quotes created were won.

    Any ideas how to achieve this?

    Any help would be greatly appreciated.

    Cheers.
    Stan

  2. #2
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    696

    Re: Need help with counting how many cell is in another worksheet

    Assume that you have 2 sheets in a workbook- Quotes & Quotes Won
    Quotes has 2 columns- Quotation Reference and Scope of Work
    Quotes Won has 2 columns- Quotation Reference and Job No.


    Try this formula in column C of Sheet "Quotes": IF(ISNA(VLOOKUP(A2,'Quotes Won'!$A$2:$A$7,1,FALSE))=TRUE,"Won","Lost")

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need help with counting how many cell is in another worksheet

    Quote Originally Posted by Shareez Saleem View Post
    Assume that you have 2 sheets in a workbook- Quotes & Quotes Won
    Quotes has 2 columns- Quotation Reference and Scope of Work
    Quotes Won has 2 columns- Quotation Reference and Job No.


    Try this formula in column C of Sheet "Quotes": IF(ISNA(VLOOKUP(A2,'Quotes Won'!$A$2:$A$7,1,FALSE))=TRUE,"Won","Lost")
    A small adjustment (you dont need the =TRUE in there)...
    IF(ISerror(VLOOKUP(A2,'Quotes Won'!$A$2:$A$7,1,FALSE)),"Won","Lost")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Need help with counting how many cell is in another worksheet

    Not tested, but try with COUNTIF:

    =IF(COUNTIF('Quotes Won'!$A$2:$A$7,A2),"WON","LOSS")
    Last edited by bebo021999; 02-02-2017 at 04:35 AM.
    Quang PT

+ 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. Replies: 8
    Last Post: 08-28-2014, 07:50 AM
  2. counting and put the result in the other worksheet
    By kachuen2006 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-15-2013, 12:39 AM
  3. [SOLVED] Counting Data on another Worksheet
    By jamesjessie117 in forum Excel General
    Replies: 10
    Last Post: 09-04-2012, 05:10 AM
  4. Counting characters of each cell and printing the result to another worksheet
    By crisshinn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2011, 05:37 AM
  5. Counting ComboBoxes on a worksheet
    By Mervil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2010, 02:58 PM
  6. counting the worksheet index
    By burugudug in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2010, 04:59 AM
  7. counting # rows in a worksheet
    By HeatherO in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-19-2005, 05: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