SUMIFS

[Jessica.Padman]

Does anyone know how to get SUMIFS for mac excel 2004? Or how else
can i do the same thing?
Thanx

 

[CyberTaz]

The SUMIF() function in Mac XL 2004 is no different than in the Win version,
but SUMIFS() are new Built-in functions in Office 2007 Only. Perhaps the
"...IFS" functions will be included in Office 2008 XL for Mac. I would think
so, but that's just a guess.

Whether something comparable can be added as a user-defined function I don't
know.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[ShaneDevenshire]

As CyberTaz confirmed this function, along with a total of 12 new ones are
not in 2004 but are in 2007, including COUNTIFS, AVERAGEIF, AVERAGEIFS,
IFERROR.

You can duplicate the result using arrays, here is an example with 4
conditions:

=SUMPRODUCT((A1>15)*(B1="Go")*(C1>=DATE(07,1,1))*(C1<=DATE(07,12,31))*Salary)

To enter this press Shift Control Enter, not Enter.