Re: PLEASE HELP TO SOLVE MY PROBLEM IN EXCEL FORMULA

[Prashant Pednekar]

this may work,

--- On Tue, 13/10/09, G. Ram <grs...@gmail.com> wrote:

> From: G. Ram <grs...@gmail.com>
> Subject: PLEASE HELP TO SOLVE MY PROBLEM IN EXCEL FORMULA
> To: karthi...@gmail.com, excelfil...@googlegroups.com
> Date: Tuesday, 13 October, 2009, 6:42 PM
> Dear sir,
>  I am having ssi unit where upto ten peoples are working
> there. i have prepare a simple weekly wages chart using
> excel.
> now i faced a problem in formula. i have attached the file.
> please help me..
>
> Thanks,
>
>
> Ram,
>
>
> >
>
>
>


From cricket scores to your friends. Try the Yahoo! India Homepage! http://in.yahoo.com/trynew

[Mukesh Kothari]

This could be one of the way

 

=SUMIF(E11:E32,"X",M11:M32)+((SUMIF(E11:E32,"X/2",M11:M32))/2)

Regards

 

Mukesh Jain

[ramu]

Thank you Mr.Mukesh.
i use the same formula now.

Thanks & regards,
Ram..

On Oct 16, 12:17 pm, Mukesh Kothari <kotharimukeshj...@gmail.com>
wrote:

> This could be one of the way
>
> =SUMIF(E11:E32,"X",M11:M32)+((SUMIF(E11:E32,"X/2",M11:M32))/2)
> Regards
>
> Mukesh Jain
> On Thu, Oct 15, 2009 at 6:31 PM, Prashant Pednekar

> <pprashan...@yahoo.co.in>wrote:
>
>
>
> > this may work,
>
> > --- On Tue, 13/10/09, G. Ram <grs1...@gmail.com> wrote: