PDA

View Full Version : Referencing Entire Workbook


Mgaines
Oct 26, 2006, 08:12 AM
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
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
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