Answer inline, therefore top-post of this line. On Mon November 26 2007 23:50:12 Brian Barker wrote: > At 16:43 26/11/2007 +0900, James Elliott wrote: <SNIPPED> > >=SUMIF((A7:A2001 = "V") AND (G1<B7:B2001<G2); sum E7:E2001) James, you may want to try something like this (please note that I have NOT tried it out with true values) =sum(if(AND(A7:A2001 = "V"; G1<B7:B2001; G2>B2:B2001);E7:E2001;0)) You'd have to use the array function, of course. If you have no confidential information in the file, and if you wish to share it with me, I can look into the issue, and send you a better response. Should you want to do that, please mail me off list. > > > >I want to add up all expenses that match a particular code and > >occurred between specified dates. <SNIPPED> <Brian's reply removed>
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
