Sum of two groups

J

JHL

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
 
L

Luke M

Change cell U11 to just 540.
=SUMPRODUCT(--(B2:B1096=T12),--(AA2:AA1096>U11),Q2:Q1096))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM and IF using two date ranges 2
Conditional Sum date range 2
Sum of two highest numbers 7
Comparing the sum of two columns with conditional formatting 0
greater of two values 1
sum a range if two conditions are met 3
Excel 2002: unexplainable difference in sum of columns 1
How to write the SUM of two MAX numbers in four or more than four cells 1

Top