Thank you its working
On Mon, Sep 3, 2012 at 5:22 PM, Amresh Maurya wrote:
> Hi Rambabu,
>
> Find the attached file.
>
> use this formula.
>
> =SUMIFS(I15:I24,K15:K24,"<"&O15,J15:J24,N15)
>
> Regards
> Amresh
>
>
>
>
> On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI
> wrote:
>
>> Please try
>>
Hi Rambabu,
Find the attached file.
use this formula.
=SUMIFS(I15:I24,K15:K24,"<"&O15,J15:J24,N15)
Regards
Amresh
On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI wrote:
> Please try
>
> =SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<="&O15)
>
>
> On Mon, Sep 3, 2012 at 5:17 PM, Rambabu
Dear Ram,
If you working in prior version of Excel 2007
You can use
=SUMPRODUCT(($J$15:$J$24=N15)*($K$15:$K$24<=O15)*($I$15:$I$24))
On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI wrote:
> Please try
>
> =SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<="&O15)
>
>
> On Mon, Sep 3, 2012 at 5:17
Please try
=SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<="&O15)
On Mon, Sep 3, 2012 at 5:17 PM, Rambabu Mudiraj wrote:
> Dear all,
>
>
> --
> Regards
> Rambabu. G
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members alre
Dear all,
--
Regards
Rambabu. G
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Co
