| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
FORMULA RETURNS #VALUE WHEN PRESCEDENT WORKBOOK CLOSED
=COUNTIF('[4DLWEDNESDAY.XLS]9501'!$I2:$U2,$AJ$3)-COUNTIF('[4DLWEDNESDAY.XLS]9501'!$W2:$AA2,$AJ$3)
I WOULD USE AN ARRAY FORMULA OF =COUNT(IF(( BUT THE CELLS I'M TRYING TO ENTER THE FORMULA INTO ARE MERGED CELLS AND WILL NOT TAKE AN ARRAY FORMULA. $AJ$3 COULD ALSO BE TEXT IE: "2M" "3C" "2A" (NOT CELL REFERENCES JUST BILLING CODES) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formula to another workbook | Excel Worksheet Functions | |||
| Link A Cell In O ne Workbook To A Formula In Another Workbook | Excel Worksheet Functions | |||
| How do I copy a cell + it's formula from one workbook to another? | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
