Prev: I can't see Grand total rows even though the option's switchedon
Next: look up formula
From: JHL on 21 Apr 2010 14:05
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

From: Luke M on 21 Apr 2010 14:29
Change cell U11 to just 540.
=SUMPRODUCT(--(B2:B1096=T12),--(AA2:AA1096>U11),Q2:Q1096))

--
Best Regards,

Luke M
"JHL" <JHL(a)discussions.microsoft.com> wrote in message
news:1AA3F696-2575-4FC9-8613-BB9DDCFCCCE5(a)microsoft.com...
>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
>



 | 
Pages: 1
Prev: I can't see Grand total rows even though the option's switchedon
Next: look up formula