allack <[EMAIL PROTECTED]>
Subject: $$Excel-Macros$$ Re: Calculate total premium amount for a selected
person.
To: excel-macros@googlegroups.com
Date: Thursday, October 23, 2008, 11:32 AM
#yiv147388595 .hmmessage P
{
margin:0px;padding:0px;}
#yiv147388595 {
FONT-SIZE:10pt;FONT-FAMILY:Tahoma
-Macros$$ Re: Calculate total premium amount for a selected
person.
To: excel-macros@googlegroups.com
Date: Thursday, October 23, 2008, 11:32 AM
#yiv245065992 .hmmessage P
{
margin:0px;padding:0px;}
#yiv245065992 {
FONT-SIZE:10pt;FONT-FAMILY:Tahoma;}
Hi,
Try this:
SUMPRODUCT(--(A2:A100="
PROTECTED]>
Subject: $$Excel-Macros$$ Re: Calculate total premium amount for a selected
person.
To: "MS Excel & VBA Macros"
Date: Thursday, October 23, 2008, 1:09 PM
You can do a pivot table or try the sumif function
Nishant
On Oct 23, 11:44 am, "Santhosh Kumar M K&quo
Hi,
Use Pivot table.
check the attachment.
On Thu, Oct 23, 2008 at 12:14 PM, Santhosh Kumar M K <[EMAIL PROTECTED]>wrote:
> Dear Friends,
>
> Please, solve my problem
>
> Find the attached data..
>
> How to calculate total premium amount for a single personusing formula
> / function?
see attachhed file for your query
On Thu, Oct 23, 2008 at 12:14 PM, Santhosh Kumar M K <[EMAIL PROTECTED]>wrote:
> Dear Friends,
>
> Please, solve my problem
>
> Find the attached data..
>
> How to calculate total premium amount for a single personusing formula
> / function?
>
>
Hi,
Try this:
SUMPRODUCT(--(A2:A100="Ramesh")*(D2:D100))
Change the name as required, or type the desired name into a spare cell, eg H1,
and use:
SUMPRODUCT(--(A2:A100=H1)*(D2:D100))
Regards - Dave.
Date: Thu, 23 Oct 2008 12:14:28 +0530
From: [EMAIL PROTECTED]
To: excel-macros@googlegroups.com
You can do a pivot table or try the sumif function
Nishant
On Oct 23, 11:44 am, "Santhosh Kumar M K" <[EMAIL PROTECTED]> wrote:
> Dear Friends,
>
> Please, solve my problem
>
> Find the attached data..
>
> How to calculate total premium amount for a single personusing formula /
> functio
