Does iWork '08 have a
sumifs type command? If not, how can I sum on multiple conditions? Essentially how do I fo the following:
Ask Different is a question and answer site for power users of Apple hardware and software. It only takes a minute to sign up.Sign up to join this community
You should still be able to do what you are trying by combining two logical statements.
Without using the function, you could also build a new column by multiplying values by a logical statement. For example:
=A3 + A4 × (B4>2)
This will only add
B4 is greater than 2...
Or in your example, make a column using
=A2 x AND(B2<10,exact(C2,"female))
Then sum that column. Values that don't meet both criteria will be zero.