Dear Friends,
Maries & Seraj...
Thanks for u r help.
Regards,
Munnu.
On 4/6/12, Seraj Alam wrote:
> Hi,
>
> Try this one also..
>
> =SUMPRODUCT(($C$2:$C$113=A2)*($D$2:$D$113))
>
> On Thu, Apr 5, 2012 at 12:20 PM, Munir Ahmad
> wrote:
>
>> Hi Group,
>>
>> please help
>>
>>
No need Value formula,
It can do it, =SUMIF($C$2:$C$113,A2,$D$2:$D$113)
On Fri, Apr 6, 2012 at 12:51 AM, Maries wrote:
> Hi,
>
> Try below formula,
>
> =SUMIF($C$2:$C$113,VALUE(A2),$D$2:$D$113)
>
> Regards,
>
> MARIES.
>
>
>
> On Thu, Apr 5, 2012 at 11:20 PM, Munir Ahmad wrote:
>
>> Hi Group,