|
|
#15
08-08-2012, 02:35 PM
|
|||
|
|||
now i am trying the following formula
=COUNTIFS(SUPPORT!H8:H25,"Martin",SUPPORT!M9:M25,Y EAR(TODAY())) and i get #Value! but when i create the same formula on the support sheet. ie =COUNTIFS(H9:H250,"Martin",M9:M250,YEAR(TODAY())) and it works. Is there limits when referencing other sheets in workbook? 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Change Resource Time vs. Duration when Updating Work column | lylel | Project | 3 | 07-23-2012 06:09 PM |
| Displaying Work Week instead of date in a column. | whitney07 | Project | 1 | 07-05-2012 02:27 PM |
 definition of work column
|
ketanco | Project | 9 | 05-31-2012 05:15 PM |
|
Right-Aligning Data to a Column
|
sunnyside | Excel | 3 | 02-27-2012 01:25 AM |
| Formula not getting copied to entire column | theacegary | Excel | 1 | 11-29-2010 02:18 PM |
Windows XP 
Office 2010 32bit
Threaded Mode