Use the following formula.
=SUMIF($A$3:$A$322,$F$3:$F$16,$C$3:$C$322)
On Fri, Aug 12, 2011 at 4:49 PM, naresh v wrote:
> I Have mentioned my problem clearlyplease find attached sheet
>
>
> Regards,
> Naresh V
>
> --
>
> ---
Any special reason for not using "Sumif"/
like : =SUMIF(A:B,H2,B:B)
On Thu, Aug 11, 2011 at 7:34 PM, Rajan_Verma wrote:
> Can you please explain it more, Do you want to Extract three Record which
> total is
> ?
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-mac
please see attachment
On Thu, Aug 11, 2011 at 7:28 PM, naresh v wrote:
> Hi friends,
>
> I have attached one excel, can you please help me ..
>
> Regards,
> Naresh V
>
> --
> --
> Some important links for excel users:
=SUMPRODUCT((A2:A22={"a","c","g"})*B2:B22)
-Original Message-
From: naresh v
Sent: Thursday, August 11, 2011 8:58 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Like pivot table function
Hi friends,
I have attached one excel, can you please help me ..
Regards,
Naresh
Can you please explain it more, Do you want to Extract three Record which
total is
?
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of naresh v
Sent: Thursday, August 11, 2011 7:28 PM
To: excel-macros@googlegroups.com
Subject: $$Exce
