View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JHL JHL is offline
external usenet poster
 
Posts: 56
Default Sum of two groups

I have the following formula attempting to get some totals by aging category.

=SUMPRODUCT(--(B2:B1096=T12),--(AA2:AA1096=U11),Q2:Q1096)

T12 = a 2 digit code of text. Example CL
U11 = 540
Q2:Q1096 = represents the dollars I want to sum

I think my problem is the aging dates range from 24 to 3293 days. I want to
break that into two categories of greater than 540, and less than 540. Is
that doable with a formula similar to the above?

I have in one cell (U11) 540 typed and in another with <540 (V11).

Your help is appreciated.
JHL