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
>
> --
>
> ---
egroups.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: $$Excel-Macros$$ Like pivot table function
>
> Hi friends,
>
> I have attached one excel,
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 plea
: $$Excel-Macros$$ Like pivot table function
Hi friends,
I have attached one excel, can you please help me ..
Regards,
Naresh V
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
Hi friends,
I have attached one excel, can you please help me ..
Regards,
Naresh V
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2.
