Arguments in a SUMIF function

[andrewc]

Hi,

I’m using a SUMIF function to evaulate some date. The second argument in the function, the criteria, is that the numbers to be summed are greater than 25 but less than 50. Can someone please tell me the syntax for that?

Thanks!

[DonkeyOte]

You can't do that in one SUMIF I'm afraid (ie that's 2 tests and not one) so either

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

or if using XL2007

Please Login or Register  to view this content.

[andrewc]

Perfect, thanks very much!