Thread: COUNTIFS equivalent in Excel 2003 - both criteria have text, one has "wildcard"
View Single Post
  #4  
Old April 20th, 2010, 03:01 AM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
  
Posts: 15,759
Default COUNTIFS equivalent in Excel 2003 - both criteria have text, one has "wildcard"
I'm getting a "#DIV/0" error.

Do you have #DIV/0! errors in any of the referenced ranges?

Try this array formula** :

=SUM(IF(LEFT('Cycle 1'!B14:B1069,4)="Auto",IF(ISNUMBER('Cycle
1'!J14:J1069),IF('Cycle 1'!J14:J1069=1,1))))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Courtney" wrote in message
.. .
Hi thanks for your quick response. I'm getting a "#DIV/0" error.
Soemthing
must be wrong because when I use COUNTIFS in 2007, the result is 26. Any
ideas of what could be causing this error or what could fix the formula?

url:http://www.ureader.com/msg/104258258.aspx