Ask Experts Questions for FREE Help !
Ask
    Mgaines's Avatar
    Mgaines Posts: 8, Reputation: 1
    New Member
    		  
    #1

    Oct 26, 2006, 08:12 AM
    Referencing Entire Workbook
    I'm sure I could probably find the answer to the question on my own but really don't have the time to search. Thinking maybe someone on here already knows. Is it possible to reference an entire workbook in a function?

    For Example:

    COUNTIF([workbook], Paid)

    Thanks
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Oct 26, 2006, 08:33 AM
    No, You can only refer to ranges.

    If you have a table where one column is marked paid, then you would only need to reference that column.
    Mgaines's Avatar
    Mgaines Posts: 8, Reputation: 1
    New Member
    		  
    #3

    Oct 26, 2006, 10:30 AM
    Well I used "Paid" as an example. I have 12 worksheets and have to reference a column in each. I know I can just sum 12 countif's but I figured there may be a shortcut but oh well. Thanks
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Worksheets within the same workbook [ 21 Answers ]

Hi, I have many worksheets within the same file, what I really want is to have either a (link / go to option) from sheet1 to other sheets without using hyperlink because I want to send to others. Example: if I click on Apple from Sheet 1, I will go to Sheet2 Sheet1 Sheet2 ...

How to find unique values in an entire column [ 10 Answers ]

hi all please tell me how can I findout the unique values in an entire coloumn. for example I have 3 coloumn in an sheet. Name Prod. Value a 24 100 b 26 240 a 33 120 a 21 200

Display not occupying entire monitor coords. [ 7 Answers ]

Am using XP and my display was compressed and is not occupying entire screen. I tried with possible resolutions but in vain. I reinstalled the software and also made the system to run in Safe mode. Found no worthness. Is this a HW or a SW problem? Please suggest an alternative. Regards, ...

Working out entire body in one day? Effective? [ 2 Answers ]

I work out my chest, arms, legs, shoulders all in one day and I work out every week. Many have been saying that I will not develop any body muscles by doing this.. and I was wondering if this was a false statement. Lots of people have a schedule to work out chests, shoulders, triceps one day.. and...

View more questions Search