| 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 | |||
| sumif returns #VALUE! when linked workbook is closed | Excel Worksheet Functions | |||
| FORMULA RETURNS #VALUE WHEN PRESCEDENT WORKBOOK CLOSED | Excel Discussion (Misc queries) | |||
| SUMIF Returns a #VALUE error when external source is closed | Excel Worksheet Functions | |||
| SUMIF Returns a #VALUE error when external source is closed | Excel Discussion (Misc queries) | |||
| SUMIF Returns a #VALUE error when external source is closed | Excel Worksheet Functions | |||
Threaded Mode
