(Edited by awckie on 02-Jul-03 18:19. Note that this did not paste as I wanted it to 
Imagine all the numbers in different columns with the headings in the row above!)
Hello…
I have a summary tab in my workbook which looks like: (But formatted nicely )
Plan # OP UC Unsubmitted In Process Approved Total Units
Anita 16 3 3 1 0 1 8
John 11 1 2 5 0 3 11
Joe 14 0 4 9 1 2 16
Carol 14 5 2 7 2 1 17
Smith 13 7 1 0 0 0 8
Taylor 10 4 2 1 0 1 8
Jen 13 3 1 6 0 2 12
Frank 19 19 1 4 0 0 24
Lou 10 2 1 3 0 0 6
Jessie 14 6 2 7 0 1 16
Each of the names in column A is the same name as a sheet in the workbook. Currently I am using CountIF formulas to get the summary numbers EX: =COUNTIF(Anita!G:G,”UC”)
Instead of having Anita in the formula I would like to have A3 (where Anita’s name is in the current summay sheet) If I just put in A3, I get a File Not Found.
Can I do what I want to do?
