Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
countif formula
i have 3 spreadsheets that i have my employees work in. i have 1 spreadsheet
that is an overview (totals) of the above 3. i need the overview sheet to show me how many A's, B's, C's are in each of the 3 spreadsheets. the current formula i have is =COUNTIF('S:\Collections\PSS Documents\PSS Data Worksheets\Maria\[Maria PSS Data Worksheet Jan ''08.xls]Existing Patients'!$K$3:$K$90,"A") i get the error "#value" now, if i have one of the 3 spreadsheets open, my overview shows the correct totals, if i close it, the totals go back to #value. this is driving me nuts. all of the other "countA" formulas i have are working fine. thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Formula | Excel Discussion (Misc queries) | |||
Please help with countif formula | Excel Discussion (Misc queries) | |||
COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED | Excel Worksheet Functions | |||
countif formula | Excel Programming | |||
CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions |