Performing calculations if a value is between A and B
 

how do i use "if" or "sumif" to perform a calculation when the statement "A
x and B<y" is true

I am trying to run calculations when a date is within a month, e.g.,
07/31/08 and <09/01/08

Performing calculations if a value is between A and B
 

How about

=IF(MONTH(DateCell)=8,calculation,other)

HTH,
Bernie
MS Excel MVP


"M. Nelson" wrote in message
...
how do i use "if" or "sumif" to perform a calculation when the statement "A
x and B<y" is true

I am trying to run calculations when a date is within a month, e.g.,
07/31/08 and <09/01/08

Performing calculations if a value is between A and B
 

=IF(AND(A1DATE(2008,31,7),B1<DATE(2008,9,1)),valu e_if_true,value_if_false)
or (if your A and B are looking at the same cell):
=IF(AND(YEAR(A1)=2008,MONTH(A1)=8),...
--
David Biddulph

"M. Nelson" wrote in message
...
how do i use "if" or "sumif" to perform a calculation when the statement
"A
x and B<y" is true

I am trying to run calculations when a date is within a month, e.g.,
07/31/08 and <09/01/08

Performing calculations if a value is between A and B
 

This formula is sum column B if column A is Aug/08

=SUMPRODUCT(--(TEXT(A1:A100,"m/yy")="8/08"),B1:B100)


"M. Nelson" wrote:

how do i use "if" or "sumif" to perform a calculation when the statement "A
x and B<y" is true

I am trying to run calculations when a date is within a month, e.g.,
07/31/08 and <09/01/08