|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 21st, 2010, 07:05 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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 
|
|
#2
April 21st, 2010, 07:29 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum of two groups
Change cell U11 to just 540.
=SUMPRODUCT(--(B2:B1096=T12),--(AA2:AA1096U11),Q2:Q1096)) -- Best Regards, Luke M "JHL" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
