functions

[Karshish]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

I have tried to use COUNTIFS to perform the following: (range1,criteria1,((range2,criteria2)-(range2,criteria3)) but it doesn't work. Any suggestions plz?

 

[Carl Witthoft]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

I have tried to use COUNTIFS to perform the following:
(range1,criteria1,((range2,criteria2)-(range2,criteria3)) but it doesn't
work. Any suggestions plz?

I don't have XL2008, but according to a web page the syntax is
COUNTIFS(range1, crit1, range2, crit2, range3,crit3,...)

Since the function basically counts up TRUE or FALSE for each datum in a
range, I'm not clear on what interim results you want to subtract from
each other.
Can you elaborate a bit?