+ Reply to Thread
Results 1 to 6 of 6

How do I extract info from my 'Data Sheet' to my 'Functions' sheet and use countif within

  1. 11-20-2020, 03:17 PM #1
    rice2
    rice2 is offline
    Registered User
    Join Date
    11-20-2020
    Location
    Alberta, Canada
    MS-Off Ver
    2016
    Posts
    3

    Question How do I extract info from my 'Data Sheet' to my 'Functions' sheet and use countif within

    I have a data sheet and I typed my functions in my Function sheet based on the data from the Data Sheet. I'm only getting the result of the first set of cells i used in my function (which is Nested IF, AND, OR). So how would I go about using countif to count the results up in my FUNCTIONS sheet? Normally, I used to do everthing on one sheet and had a separate column for the functions and I just dragged down the formula using autofill but seeing as how I'm on a different sheet, it's more complicated for me. Can you please help?
    Attached Images Attached Images
    Last edited by rice2; 11-20-2020 at 07:09 PM.
    Reply With QuoteRegister To Reply
  2. 11-20-2020, 03:44 PM #2
    mikeava
    mikeava is offline
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    Re: How do I extract info from my 'Data Sheet' to my 'Functions' sheet and use countif wit

    Hi - can you attach your file?
    Reply With QuoteRegister To Reply
  3. 11-20-2020, 04:08 PM #3
    rice2
    rice2 is offline
    Registered User
    Join Date
    11-20-2020
    Location
    Alberta, Canada
    MS-Off Ver
    2016
    Posts
    3

    Re: How do I extract info from my 'Data Sheet' to my 'Functions' sheet and use countif wit

    it's telling me too large to process
    Reply With QuoteRegister To Reply
  4. 11-20-2020, 05:47 PM #4
    mikeava
    mikeava is offline
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    Re: How do I extract info from my 'Data Sheet' to my 'Functions' sheet and use countif wit

    Can you just post a small sample size then so we can get the jest of what you have and what you are trying to do?
    Reply With QuoteRegister To Reply
  5. 11-20-2020, 07:08 PM #5
    rice2
    rice2 is offline
    Registered User
    Join Date
    11-20-2020
    Location
    Alberta, Canada
    MS-Off Ver
    2016
    Posts
    3

    Re: How do I extract info from my 'Data Sheet' to my 'Functions' sheet and use countif wit

    Good idea. So i'm trying to answer those tests (in 2 separate questions) with what i provided. Let me know if u wanna see my functions.
    Reply With QuoteRegister To Reply
  6. 11-21-2020, 12:20 AM #6
    Gregb11
    Gregb11 is offline
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,823

    Re: How do I extract info from my 'Data Sheet' to my 'Functions' sheet and use countif wit

    Please read the yellow banner at the top of the page. And attach a file.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Extract Info from Cell and Calculate to a new sheet
    By Judylily in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-16-2017, 03:38 PM
  2. Button takes info from Sheet 1, transcribes to Sheet 2, info deletes on Sheet 1
    By LNT225 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-02-2016, 04:54 PM
  3. [SOLVED] Extract Info from sheet in a certain order **WILL PAY**
    By Lifeless in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2014, 09:15 PM
  4. Extract info from a large dynamic excel sheet.
    By indesh in forum Excel General
    Replies: 12
    Last Post: 07-29-2013, 08:02 AM
  5. Extract Info from 1 sheet to the next
    By Oly Steel Man in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-20-2011, 11:21 AM
  6. Extract info from tab sheets to master sheet
    By sonyamartinez1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2011, 04:22 PM
  7. [SOLVED] macro to extract info and paste to a new sheet
    By Brad K. in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2005, 07:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1