Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Referencing Entire Workbook (https://www.askmehelpdesk.com/showthread.php?t=39182)

  • Oct 26, 2006, 08:12 AM
    Mgaines
    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
  • Oct 26, 2006, 08:33 AM
    ScottGem
    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.
  • Oct 26, 2006, 10:30 AM
    Mgaines
    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

  • All times are GMT -7. The time now is 03:36 AM.