|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 9th 12, 08:56 AM
|
|||
|
|||
Countifs with error #Value!
I am using the following formula to reference a sheet called SUPPORT
=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? Regards Rob Last edited by masterdineen : August 9th 12 at 09:01 AM. 
|
| Ads |
|
#2
August 9th 12, 03:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countifs with error #Value!
Hi Rob,
Am Thu, 9 Aug 2012 07:56:18 +0000 schrieb masterdineen: > I am using the following formula to reference a sheet called SUPPORT > > =COUNTIFS(SUPPORT!H8:H25,"Martin",SUPPORT!M9:M25,Y EAR(TODAY())) ^^^^^^^^^ ^^^^^^^^^ try: =COUNTIFS(SUPPORT!H8:H25,"Martin",SUPPORT!M8:M25,Y EAR(TODAY())) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| COUNTIFS | AlexW | Excel Discussion (Misc queries) | 2 | January 29th 10 09:31 PM |
| countifs | gus | New Users to Excel | 2 | November 18th 09 05:16 AM |
| CountIfs | farid2001 | Excel Programming | 5 | April 11th 09 04:50 AM |
| Countifs to Sumproduct for 2003 -> was Simple Countifs.. from Fr | Steve | Excel Worksheet Functions | 2 | January 4th 09 05:36 PM |
| COUNTIFS | Skinman | Excel Worksheet Functions | 3 | December 11th 08 05:29 AM |
Linear Mode
