Hi Rakesh,
PFA, hope it will works for you..
On 17 April 2013 17:23, Rakesh Kumar Sharma wrote:
> Dear Experts,
>
> I want the month wise sum amt where the column "tr" is #N/A. I used SUMIF
> but i don't know how to use conditional sumif.
>
>
> --
> Regards,
>
> Rakesh Kumar Sharma
> Contact:
$$ How to Use Conditional SUMIF
pfa
On Wed, Apr 17, 2013 at 5:23 PM, Rakesh Kumar Sharma
wrote:
Dear Experts,
I want the month wise sum amt where the column "tr" is #N/A. I used SUMIF
but i don't know how to use conditional sumif.
--
Regards,
Rakesh Kumar Shar
Hi Rakesh ,
Please see the attached file.To Find the solution of your problem.
Regards
Priti verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Gaurav Garg
Sent: 17 April 2013 5:31
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How
Dear Rakesh,
find the same with using Sumproduct formula .
Reg,
Prafull
On Wed, Apr 17, 2013 at 5:23 PM, Rakesh Kumar Sharma wrote:
> Dear Experts,
>
> I want the month wise sum amt where the column "tr" is #N/A. I used SUMIF
> but i don't know how to use conditional sumif.
>
>
> --
> Regards,
pfa
On Wed, Apr 17, 2013 at 5:23 PM, Rakesh Kumar Sharma wrote:
> Dear Experts,
>
> I want the month wise sum amt where the column "tr" is #N/A. I used SUMIF
> but i don't know how to use conditional sumif.
>
>
> --
> Regards,
>
> Rakesh Kumar Sharma
> Contact: +91-9971024741
>
> --
> Are you
