Thread: Performing calculations if a value is between A and B
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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
Reply With QuoteReply With Quote